Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRTIMEFORM


                            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
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

TRF-FORM-TYPE          Alpha 1                                   HS01.1
Element: 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
Element: Group Name    Contains the Employee Group name.

TRF-FORM-FIELD         Alpha 10                                  HS01.1
Element: 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
Element: Field Order NuContains the field order value.

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

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

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

TRF-REQUIRED           Alpha 1                                   HS01.1
Element: All Flag      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
Element: 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