Employee Absence Plan
REFERENCED BY
HR170 | HR70.1 | HS17.1 | HS19.1 | HS19.2 | ZH500 |
HS706 | LP04.2 | LP04.3 | LP04.4 | LP04.5 | LP04.6 |
LP04.7 | LP04.8 | LP04.9 | LP231 | LP264 | LP64.1 |
LP64.2 | LP64.3 | LP65.1 | LP88.1 | PR160 | PR180 |
LP01.1 | LP63.1 | LP63.2 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TEM-COMPANY Element: Company Hr | Numeric 4 |
|
||||||||||||||||||||||||
TEM-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. |
|
||||||||||||||||||||||||
TEM-PLAN Element: Ta Plan | Alpha 10 |
|
||||||||||||||||||||||||
TEM-EMPLOYEE-GROUP Element: Group Name | Alpha 10 |
|
||||||||||||||||||||||||
TEM-HM-PROC-LEVEL Element: Process Lev Hr | Alpha 5 |
|||||||||||||||||||||||||
TEM-POSITION Element: Position | Alpha 12 Contains the user-defined code that represents a position in the company. |
|
||||||||||||||||||||||||
TEM-MASTR-ENTRY Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-MSTR-ELIG-END Element: Ta End Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-MSTR-END Element: Ta End Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-STRUCTURE-END Element: Ta End Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-MSTR-OVERRIDE Element: Ta Override | Numeric 1 0 = No 1 = Yes |
|
||||||||||||||||||||||||
TEM-SRV-BEGIN-DT Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-ACCR-BEGIN-DT Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-ACCR-START-DT Element: Ta Start Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-ACCR-LAST-DT Element: Ta Last Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-ALLOT-POINT Element: Ta Point | Numeric 4 (mmdd) |
|
||||||||||||||||||||||||
TEM-ALLOT-BEGIN-DT Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-ALLOT-LAST-DT Element: Ta Last Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-ELIG-BEGIN-DT Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-ELIG-LAST-DT Element: Ta Last Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-RESET-POINT Element: Ta Point | Numeric 4 (mmdd) |
|
||||||||||||||||||||||||
TEM-RESET-LAST-DT Element: Ta Last Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-CARRYOVER-END Element: Ta End Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-AVAIL-HRS-BAL Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-ACCR-HRS-BAL Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-ALLOT-HRS-BAL Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-RESRV-HRS-BAL Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-CARRY-HRS-BAL Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-AVAIL-ERN-BAL Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-ACCR-ERN-BAL Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-ALLOT-ERN-BAL Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-RESRV-ERN-BAL Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-CARRY-ERN-BAL Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||||||||||||
TEM-OV-CARRY-HRS-A Element: Ta Carry Amt | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-OV-CARRY-ERN-A Element: Ta Carry Amt | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-HRS-ACCR-CO Element: Company | Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. |
|
||||||||||||||||||||||||
TEM-HRS-ACCR-UNIT Element: Acct Unit | Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. |
|
||||||||||||||||||||||||
TEM-HRS-ACCR-ACCT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
||||||||||||||||||||||||
TEM-HRS-ACCR-SUB Element: Sub Acct | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||||||||||||||||||||||||
TEM-HRS-EXP-CO Element: Company | Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. |
|
||||||||||||||||||||||||
TEM-HRS-EXP-UNIT Element: Acct Unit | Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. |
|
||||||||||||||||||||||||
TEM-HRS-EXP-ACCT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
||||||||||||||||||||||||
TEM-HRS-EXP-SUB Element: Sub Acct | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||||||||||||||||||||||||
TEM-HRS-ACTIVITY Element: Activity | Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. |
|
||||||||||||||||||||||||
TEM-HRS-ACCT-CAT Element: Acct Category | Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru |
|
||||||||||||||||||||||||
TEM-ERN-ACCR-CO Element: Company | Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. |
|
||||||||||||||||||||||||
TEM-ERN-ACCR-UNIT Element: Acct Unit | Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. |
|
||||||||||||||||||||||||
TEM-ERN-ACCR-ACCT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
||||||||||||||||||||||||
TEM-ERN-ACCR-SUB Element: Sub Acct | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||||||||||||||||||||||||
TEM-ERN-EXP-CO Element: Company | Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. |
|
||||||||||||||||||||||||
TEM-ERN-EXP-UNIT Element: Acct Unit | Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. |
|
||||||||||||||||||||||||
TEM-ERN-EXP-ACCT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
||||||||||||||||||||||||
TEM-ERN-EXP-SUB Element: Sub Acct | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||||||||||||||||||||||||
TEM-ERN-ACTIVITY Element: Activity | Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. |
|
||||||||||||||||||||||||
TEM-ERN-ACCT-CAT Element: Acct Category | Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru |
|
||||||||||||||||||||||||
TEM-LAST-OBJ-ID Element: Obj Id | Numeric 12 This field is not currently being used by Absence Management. Reserve for future use. |
|
||||||||||||||||||||||||
TEM-LST-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||||||||||||||||||||||
TEM-LST-OBJ-ID-HRS Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|
||||||||||||||||||||||||
TEM-LST-OBJ-ID-ERN Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|
||||||||||||||||||||||||
TEM-LST-PER-DT-HRS Element: Ta Last Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-LST-PER-DT-ERN Element: Ta Last Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-HRH-OBJ-ID Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|
||||||||||||||||||||||||
TEM-OV-ACCR-HRS Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-ACCR-ERN Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-ALLOT-HRS Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-ALLOT-ERN Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-BAL-HRS Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-BAL-ERN Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-ACRLIM-HRS Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-ACRLIM-ERN Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-CARRY-HRS-T Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-CARRY-ERN-T Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-HRS-LIA Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-ERN-LIA Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-T-SRV-BEGIN-D Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-ACCR-BEGIN-D Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-ACCR-START-D Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-ACCR-LAST-D Element: Ta Last Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-ALLOT-POINT Element: Ta Point | Numeric 4 (mmdd) |
|
||||||||||||||||||||||||
TEM-T-ALLOT-BEGIND Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-ALLOT-LAST-D Element: Ta Last Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-ELIG-BEGIN-D Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-ELIG-LAST-D Element: Ta Last Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-RESET-POINT Element: Ta Point | Numeric 4 (mmdd) |
|
||||||||||||||||||||||||
TEM-T-RESET-LAST-D Element: Ta Last Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-CARRY-END-D Element: Ta End Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-LST-PER-DT-E Element: Ta End Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-LST-PER-DT-H Element: Ta End Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
TEM-T-LST-OBJ-ID-E Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|
||||||||||||||||||||||||
TEM-T-LST-OBJ-ID-H Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|
||||||||||||||||||||||||
TEM-T-AVAIL-HRS-B Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-T-ACCR-HRS-B Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-T-ALLOT-HRS-B Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-T-RESRV-HRS-B Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-T-CARRY-HRS-B Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-T-AVAIL-ERN-B Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-T-ACCR-ERN-B Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-T-ALLOT-ERN-B Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-T-RESRV-ERN-B Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-T-CARRY-ERN-B Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-T-RUN-FLAG Element: Ta Run Flag | Numeric 1 0 = No Transactions Processed 1 = Transactions Processed 2 = LP130 transactions processed |
|
||||||||||||||||||||||||
TEM-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. |
|
||||||||||||||||||||||||
TEM-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||||||||||||
TEM-CREATE-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||||||||||||||||||||||||
TEM-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. |
|
||||||||||||||||||||||||
TEM-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||||||||||||
TEM-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||||||||||||||||||||||||
TEM-OV-HRS-NEG-BAL Element: Ta Negativ Bal | Numeric 1 0 = Do not override 1 = Warning 2 = Error 3 = Do not check balances 4 = Reclassify as unpaid time |
|
||||||||||||||||||||||||
TEM-OV-ERN-NEG-BAL Element: Ta Negativ Bal | Numeric 1 0 = Do not override 1 = Warning 2 = Error 3 = Do not check balances 4 = Reduce to plan balance |
|
||||||||||||||||||||||||
TEM-OV-HRS-NEG-WEB Element: Ta Negativ Bal | Numeric 1 0 = Do not override 1 = Warning 2 = Error 3 = Do not check balances 4 = Reclassify as unpaid time |
|
||||||||||||||||||||||||
TEM-OV-ERN-NEG-WEB Element: Ta Negativ Bal | Numeric 1 0 = Do not override 1 = Warning 2 = Error 3 = Do not check balances 4 = Reduce to plan balance |
|
||||||||||||||||||||||||
TEM-OV-HRS-NEG-LMT Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-OV-HRS-LINK-TB Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-HRS-PRO-ORD Element: Ta Proc Order | Numeric 1 0 = Do not override 1 = Link plans 2 = Orig neg bal limit 3 = Link plans; orig neg bal limit 4 = Link plans; link neg bal limit 5 = Orig neg bal limit; link plans 6 = Org ng bal lmt; link; link lmt |
|
||||||||||||||||||||||||
TEM-OV-HRS-UNPD-CD Element: Ta Service Cd | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-ERN-NEG-LMT Element: Ta Amount | Signed 18.6 |
|
||||||||||||||||||||||||
TEM-OV-ERN-LINK-TB Element: Ta Table | Alpha 10 |
|
||||||||||||||||||||||||
TEM-OV-ERN-PRO-ORD Element: Ta Proc Order | Numeric 1 0 = Do not override 1 = Link plans 2 = Orig neg bal limit 3 = Link plans; orig neg bal limit 4 = Link plans; link neg bal limit 5 = Orig neg bal limit; link plans 6 = Org ng bal lmt; link; link lmt |
|
||||||||||||||||||||||||
TEM-TRANSFER-FLAG Element: Flag Num | Numeric 1 0 = Open 1 = Stop Events 8 = Stop Events;Closed 9 = Closed |
|
||||||||||||||||||||||||
TEM-ACCUM-HRS-LIA Element: Accum Hrs Lia | Signed 18.6 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TEMSET1 |
COMPANY EMPLOYEE PLAN EMPLOYEE-GROUP POSITION |
|
|||||||||||||||||||||||||||||||||||||
TEMSET2 |
COMPANY PLAN EMPLOYEE-GROUP EMPLOYEE POSITION |
|
| ||||||||||||||||||||||||||||||||||||
TEMSET3 |
COMPANY EMPLOYEE EMPLOYEE-GROUP PLAN POSITION |
|
| ||||||||||||||||||||||||||||||||||||
TEMSET4 |
COMPANY EMPLOYEE POSITION PLAN EMPLOYEE-GROUP |
|
| ||||||||||||||||||||||||||||||||||||
TEMSET5 |
COMPANY HM-PROC-LEVEL EMPLOYEE PLAN EMPLOYEE-GROUP POSITION |
|
| ||||||||||||||||||||||||||||||||||||
TEMSET6 |
COMPANY HM-PROC-LEVEL PLAN EMPLOYEE-GROUP EMPLOYEE POSITION |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| ||||||||||||||||||||||||||||||
Currency | CUCODES |
Required
| ||||||||||||||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||||||||||||||
Employee Group | PERSGROUP |
Required
| ||||||||||||||||||||||||||||||
Ern Accr Dist | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Ern Acct Cat | ACACCTCAT |
Required
| ||||||||||||||||||||||||||||||
Ern Activity | ACACTIVITY |
Required
| ||||||||||||||||||||||||||||||
Ern Exp Dist | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Ern Link Table | LPLINK |
Required
| ||||||||||||||||||||||||||||||
Hm Proc Level | PRSYSTEM |
Required
| ||||||||||||||||||||||||||||||
Hrs Accr Dist | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Hrs Acct Cat | ACACCTCAT |
Required
| ||||||||||||||||||||||||||||||
Hrs Activity | ACACTIVITY |
Required
| ||||||||||||||||||||||||||||||
Hrs Exp Dist | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Hrs Link Table | LPLINK |
Required
| ||||||||||||||||||||||||||||||
Ov Hrs Unpd Cd | TASERVCODE |
Required
| ||||||||||||||||||||||||||||||
Paemployee | PAEMPLOYEE |
Required
| ||||||||||||||||||||||||||||||
Plan | TAPLAN |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Accr Ern Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Accr Hrs Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Acrlim Ern Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Acrlim Hrs Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Allot Ern Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Allot Hrs Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Bal Ern Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Bal Hrs Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Bn Ta Employee | BNTAEMPBAL |
| ||||||||||||||||||||||||||||||||||||
Carry Ern Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Carry Hrs Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Ern Lia Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Hrhistory | HRHISTORY |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Hrs Lia Tbl | TATABLE |
| ||||||||||||||||||||||||||||||||||||
Lppendreq | LPPENDREQ |
| ||||||||||||||||||||||||||||||||||||
Position | PAPOSITION |
| ||||||||||||||||||||||||||||||||||||
Ta Enrl No Pos | TAENROLL |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Ta Enroll | TAENROLL |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Taemptrans | TAEMPTRANS |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Taloshrs | TALOSHRS |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Tastructur | TASTRUCTUR |
| ||||||||||||||||||||||||||||||||||||
Tatransum | TATRANSUM |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.