| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
TES-COMPANY
Element: Company Hr | Numeric 4
|
|
TES-EMPLOYEE
Element: Employee | Numeric 9
Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
|
|
TES-TES-OBJ-ID
Element: Tes Obj Id | Numeric 12
|
|
TES-SERVICE-CODE
Element: Ta Service Cd | Alpha 10
|
|
TES-EVENT-FLAG
Element: Event Flag | Numeric 1
0 = No
1 = Yes |
|
TES-REASON-CODE
Element: Ta Reason Cd | Alpha 4
|
|
TES-EVENT-TYPE
Element: Event Type | Numeric 1
1 = Absence
2 = Non Absence |
|
TES-PLAN-BALANCE
Element: Lp Plan Bal | Numeric 1
0 = None
1 = Available
2 = Reserve |
|
TES-SERVICE-STATUS
Element: Service Status | Numeric 1
0 = Created
2 = Processed
9 = Closed |
|
TES-EVENT-STATUS
Element: Event Status | Numeric 1
0 = Created
1 = Not Processed
2 = Processed
9 = Closed |
|
TES-STATUS
Element: Status | Numeric 1
This field displays the status of the
transaction.
0 = Batch
1 = Future
2 = Current
3 = Error
4 = Processed
5 = Manual
9 = Closed |
|
TES-TIME-SEQ
Element: Time Seq | Numeric 12
|
|
TES-EXT-TIME-SEQ
Element: Ext Time Seq | Numeric 12
|
|
TES-TR-DATE
Element: Tr Date | Numeric 8 (yyyymmdd)
|
|
TES-PER-END-DATE
Element: Per End Date | Numeric 8 (yyyymmdd)
Identifies period end date in
distribution record; used during PR198
to relieve salary encumbrance
commitments for pay period (updated from
TIMERECORD.PER-END-DATE).
|
|
TES-PROCESS-LEVEL
Element: Process Lev Hr | Alpha 5
|
|
TES-HM-PROC-LEVEL
Element: Process Lev Hr | Alpha 5
|
|
TES-DEPARTMENT
Element: Department | Alpha 5
Contains the department.
|
|
TES-POSITION
Element: Position | Alpha 12
Contains the user-defined code that
represents a position in the company.
|
|
TES-JOB-CODE
Element: Job Code | Alpha 9
Contains a user-defined code that
represents a type of job.
|
|
TES-HOURS
Element: Hours | Signed 7.2
Contains the hours.
|
|
TES-WAGE-AMOUNT
Element: Ta Wage Amount | Signed 18.2
|
|
TES-CURRENCY-CODE
Element: Currency Code | Alpha 5
This field contains the company base
currency code established in Company
(GL10.1 ).
|
|
TES-CURR-ND
Element: Acct Nd | Numeric 1
The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
TES-PCD-SEQ-NBR
Element: Pcd Seq Nbr | Numeric 8
|
|
TES-POINTS
Element: Points | Signed 7.2
|
|
TES-OCCURRENCE
Element: Occurrence | Alpha 1
1 = No
2 = Yes |
|
TES-DAYS-IND
Element: Days Ind | Numeric 1
1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday |
|
TES-CREATE-DATE
Element: Date Stamp | Numeric 8 (yyyymmdd)
This field contains the server date
(month, date, and year) of the last
change to this record.
|
|
TES-CREATE-TIME
Element: Time Stamp | Numeric 6 (hhmmss)
Contains the server time (hour, minute,
and second) when the record was last
changed.
|
|
TES-CREATE-USER-ID
Element: User | Alpha 10 (Lower Case)
|
|
TES-DATE-STAMP
Element: Date Stamp | Numeric 8 (yyyymmdd)
This field contains the server date
(month, date, and year) of the last
change to this record.
|
|
TES-TIME-STAMP
Element: Time Stamp | Numeric 6 (hhmmss)
Contains the server time (hour, minute,
and second) when the record was last
changed.
|
|
TES-USER-ID
Element: User | Alpha 10 (Lower Case)
|
|
TES-CREATED-NG-BAL
Element: Time Acc Flag | Alpha 1
A = Created by LP Neg Bal Options |
|
TES-REQ-OBJ-ID
Element: Req Obj Id | Numeric 12
|
|
TES-RESTORE-DATE
Element: Date | Numeric 8 (yyyymmdd)
|
|
TES-ABN-OBJ-ID
Element: Abn Obj Id | Numeric 12
|
|
| NAME |
KEY FIELDS |
DESCRIPTION / SUBSET CONDITION |
USED IN |
| TESSET1 |
COMPANY
EMPLOYEE
TES-OBJ-ID
|
|
|
| TESSET10 |
COMPANY
EMPLOYEE
TR-DATE
TES-OBJ-ID
|
|
|
| TESSET11 |
COMPANY
PROCESS-LEVEL
DEPARTMENT
SERVICE-STATUS
EVENT-STATUS
JOB-CODE
EMPLOYEE
TES-OBJ-ID
SERVICE-CODE
REASON-CODE
|
|
|
| TESSET2 |
COMPANY
EMPLOYEE
TR-DATE
TES-OBJ-ID
|
|
KeyChange, Subset |
| Where | (( | STATUS |
= | 2 | ) |
| Or | ( | STATUS |
= | 3 | ) |
| Or | ( | STATUS |
= | 4 | ) |
| Or | ( | STATUS |
= | 5 | ) |
| Or | ( | STATUS |
= | 9 | )) |
| And | ( | SERVICE-CODE |
!= | Spaces | ) |
|
|
| TESSET3 |
COMPANY
EMPLOYEE
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
TR-DATE
TES-OBJ-ID
|
|
KeyChange, Subset |
| Where | ( | SERVICE-CODE |
!= | Spaces | ) |
|
|
| TESSET4 |
COMPANY
EMPLOYEE
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
PER-END-DATE
TES-OBJ-ID
|
|
KeyChange, Subset |
| Where | (( | STATUS |
= | 2 | ) |
| Or | ( | STATUS |
= | 3 | ) |
| Or | ( | STATUS |
= | 4 | ) |
| Or | ( | STATUS |
= | 5 | ) |
| Or | ( | STATUS |
= | 9 | )) |
| And | ( | SERVICE-CODE |
!= | Spaces | ) |
|
|
| TESSET5 |
COMPANY
EMPLOYEE
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
TR-DATE
TES-OBJ-ID
|
|
KeyChange, Subset |
| Where | ( | SERVICE-CODE |
!= | Spaces | ) |
| And | ( | PLAN-BALANCE |
!= | Zeroes | ) |
| And | ( | EVENT-STATUS |
!= | 9 | ) |
| And | (( | STATUS |
= | 2 | ) |
| Or | ( | STATUS |
= | 3 | ) |
| Or | ( | STATUS |
= | 4 | ) |
| Or | ( | STATUS |
= | 5 | ) |
| Or | ( | STATUS |
= | 9 | )) |
|
|
| TESSET6 |
COMPANY
EMPLOYEE
PER-END-DATE
TES-OBJ-ID
|
|
KeyChange, Subset |
| Where | (( | STATUS |
= | 2 | ) |
| Or | ( | STATUS |
= | 3 | ) |
| Or | ( | STATUS |
= | 4 | ) |
| Or | ( | STATUS |
= | 5 | ) |
| Or | ( | STATUS |
= | 9 | )) |
| And | ( | SERVICE-CODE |
!= | Spaces | ) |
|
|
| TESSET7 |
COMPANY
HM-PROC-LEVEL
EMPLOYEE
TES-OBJ-ID
|
|
|
| TESSET8 |
COMPANY
EMPLOYEE
TR-DATE
TES-OBJ-ID
|
|
KeyChange, Subset |
| Where | ( | SERVICE-STATUS |
!= | 9 | ) |
| And | ( | EVENT-STATUS |
!= | 9 | ) |
|
|
| TESSET9 |
COMPANY
EMPLOYEE
TR-DATE*
TES-OBJ-ID*
SERVICE-STATUS
EVENT-STATUS
|
|
|
RELATION
NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
| Company |
PRSYSTEM |
Required
| TES-COMPANY | -> | PRS-COMPANY |
| Spaces | -> | PRS-PROCESS-LEVEL |
|
| Currency |
CUCODES |
Required
| When | ( | TES-CURRENCY-CODE | != | Spaces | ) |
| TES-CURRENCY-CODE | -> | CUC-CURRENCY-CODE |
|
| Department |
DEPTCODE |
Required
| When | ( | TES-DEPARTMENT | != | Spaces | ) |
| TES-COMPANY | -> | DPT-COMPANY |
| TES-PROCESS-LEVEL | -> | DPT-PROCESS-LEVEL |
| TES-DEPARTMENT | -> | DPT-DEPARTMENT |
|
| Employee |
EMPLOYEE |
Required
| TES-COMPANY | -> | EMP-COMPANY |
| TES-EMPLOYEE | -> | EMP-EMPLOYEE |
|
| Hm Proc Level |
PRSYSTEM |
Required
| When | | TES-HM-PROC-LEVEL | != | Spaces | |
| TES-COMPANY | -> | PRS-COMPANY |
| TES-HM-PROC-LEVEL | -> | PRS-PROCESS-LEVEL |
|
| Job Code |
JOBCODE |
Required
| When | ( | TES-JOB-CODE | != | Spaces | ) |
| TES-COMPANY | -> | JBC-COMPANY |
| TES-JOB-CODE | -> | JBC-JOB-CODE |
|
| Paemployee |
PAEMPLOYEE |
Required
| TES-COMPANY | -> | PEM-COMPANY |
| TES-EMPLOYEE | -> | PEM-EMPLOYEE |
|
| Pay Code |
PRPAYCODE |
Required
| When | | TES-PCD-SEQ-NBR | != | Zeroes | |
| TES-COMPANY | -> | PCD-COMPANY |
| TES-PCD-SEQ-NBR | -> | PCD-SEQ-NBR |
|
| Process Level |
PRSYSTEM |
Required
| When | ( | TES-PROCESS-LEVEL | != | Spaces | ) |
| TES-COMPANY | -> | PRS-COMPANY |
| TES-PROCESS-LEVEL | -> | PRS-PROCESS-LEVEL |
|
| Reason Code |
TAREASCODE |
Required
| When | ( | TES-REASON-CODE | != | Spaces | ) |
| TES-COMPANY | -> | TRE-COMPANY |
| TES-REASON-CODE | -> | TRE-REASON-CODE |
|
| Service Code |
TASERVCODE |
Required
| When | ( | TES-SERVICE-CODE | != | Spaces | ) |
| TES-COMPANY | -> | TSC-COMPANY |
| TES-SERVICE-CODE | -> | TSC-SERVICE-CODE |
|
| Timerecord |
TIMERECORD |
Not Required
| TES-COMPANY | -> | TRD-COMPANY |
| TES-EMPLOYEE | -> | TRD-EMPLOYEE |
| TES-TIME-SEQ | -> | TRD-TIME-SEQ |
|
