Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PRTIMEFORM FILE

The Web Time Record Form file contains the records that make up a Web Time
Entry Form.

REFERENCED BY

HS20.1    HS22.1    HS36.1

UPDATED BY

HS01.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TRF-COMPANY          Numeric 4                                   HS01.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.


TRF-FORM-TYPE        Alpha 1                                     HS01.1
Form Type            Contains the value that determines the
                     type of time record form.  Valid values
                     are:

                     0 = Employee.

                     M = Manager.

                     " " = Employee
                     P = Proxy

TRF-GROUP-NAME       Alpha 10                                    HS01.1  HS36.1
Group Name           Contains the Employee Group name.

TRF-FORM-FIELD       Alpha 10                                    HS01.1
Form Field           Contains the time record field name to
                     be used on the Web time record form.

                     ACCT CAT = Account Category
                     ACCT UNIT = Accounting Unit
                     GL ACCOUNT = GL Account
                     ACT GRP = Activity Group
                     ACTIVITY = Activity
                     ATTEND CD = Attendance Code
                     COMMENTS = Comments
                     DEPARTMENT = Department
                     GL COMPANY = GL Company
                     GRADE = Grade
                     HOURS = Hours
                     JOB CODE = Job Code
                     OCCURRENCE = Occurrence
                     PAY CODE = Pay Code
                     PROC LEVEL = Process Level
                     POSITION = Position
                     RATE = Rate
                     SCHEDULE = Schedule
                     SHIFT = Shift
                     STEP = Step
                     SUB ACCT = GL Sub Account
                     USERFIELD1 = User Field 1
                     USERFIELD2 = User Field 2

TRF-ORDER            Numeric 2                                   HS01.1
Order                Contains the field order value.

TRF-LABEL            Alpha 20                                    HS01.1
Label                Contains the value to be used as the
                     field label.


TRF-SIZE-FIELD       Signed 4.1                                  HS01.1
Size Field           Contains the value of the field size.

TRF-DEFAULT-FIELD    Alpha 30                                    HS01.1
Default Field        Contains the value of the field default.


TRF-REQUIRED         Alpha 1                                     HS01.1
Required             Contains the value that determines if
                     the form field is required.  Valid
                     values are:

                     Y = Yes.

                     N = No.


TRF-USE-DESC         Alpha 1                                     HS01.1
Use Desc             Y = Yes
                     N = No

                         PRTIMEFORM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRFSET1   COMPANY                                                HS01.1  HS20.1
          FORM-TYPE                                              HS22.1  HS36.1
          GROUP-NAME
          FORM-FIELD

                         PRTIMEFORM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Not Required
                            Valid When TRF-FORM-FIELD = "ACCT CAT  "

                            TRF-FORM-FIELD    -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Not Required
                            Valid When TRF-FORM-FIELD = "ACTIVITY  "

                            TRF-FORM-FIELD    -> ACV-ACTIVITY

Attendcode     ATTENDCODE   Not Required
                            Valid When TRF-FORM-FIELD = "ATTEND CD "

                            TRF-COMPANY       -> ATC-COMPANY
                            TRF-FORM-FIELD    -> ATC-ATTEND-CODE

Group Name     PERSGROUP    Required

                            TRF-COMPANY       -> PRG-COMPANY
                            TRF-GROUP-NAME    -> PRG-GROUP-NAME

Jobcode        JOBCODE      Not Required
                            Valid When TRF-FORM-FIELD = "JOB       "

                            TRF-COMPANY       -> JBC-COMPANY
                            TRF-FORM-FIELD    -> JBC-JOB-CODE

Prsystem       PRSYSTEM     Not Required

                            TRF-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

                         PRTIMEFORM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Deptcode       DEPTCODE
                            Valid When TRF-FORM-FIELD = "DEPARTMENT"

                            TRF-COMPANY       -> DPT-COMPANY
                                                 DPT-PROCESS-LEVEL
                                                 DPT-DEPARTMENT

Glmaster       GLMASTER
                            Valid When TRF-FORM-FIELD = "ACCOUNT   "

                            TRF-COMPANY       -> GLM-COMPANY
                                                 GLM-ACCOUNT
                                                 GLM-SUB-ACCOUNT
                                                 GLM-VAR-LEVELS
                                                 GLM-ACCT-UNIT

Glnames        GLNAMES
                            Valid When TRF-FORM-FIELD = "ACCT UNIT "

                            TRF-COMPANY       -> GLN-COMPANY
                                                 GLN-ACCT-UNIT

Paycode        PRPAYCODE
                            Valid When TRF-FORM-FIELD = "PAY CODE  "

                            TRF-COMPANY       -> PCD-COMPANY
                                                 PCD-PROCESS-LEVEL
                                                 PCD-JOB-CODE
                                                 PCD-PAY-CODE

Schedule       PRSAGHEAD

                            TRF-COMPANY       -> SGH-COMPANY
                                                 SGH-INDICATOR
                                                 SGH-SCHEDULE
                                                 SGH-EFFECT-DATE