| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVHCM_COMPARLOG | TDMS4HCM: Protocoll information for payroll compare | 9 | RUNDT | TDMS4HCM: Date of payroll run | nvarchar | 8 | 0 | | |
2 | HRDCT_TPY_RGDIR | Declustering - Directory for Test Payroll Results | 20 | RUNDT | Date of payroll run | nvarchar | 8 | 0 | | |
3 | P08P1CLD | CLASS Interface Clear-down Parameter File | 2 | RUNDT | CLASS CPX INTERFACE Control File Run Date | nvarchar | 8 | 0 | | |
4 | P2RX_ARRRS | Payroll Results: Arrears Table | 10 | RUNDT | Off-cycle payroll payment date | nvarchar | 8 | 0 | | |
5 | P2RX_VERSC | Payroll Status Information | 29 | RUNDT | Date of payroll run | nvarchar | 8 | 0 | | |
6 | T5UMR | Cross month retro-calculations | 7 | RUNDT | Generation Date | nvarchar | 8 | 0 | | |
7 | T7CNTPM_USAGE | TPM: Usage Data | 8 | RUNDT | Run Date of Usage Data | nvarchar | 8 | 0 | | |
TOPAustria |
8 | HRPAYAT_PAYRSRES | Saves Wage Types from Simulated Payroll Results | 24 | RUNDT | Date of payroll run | nvarchar | 8 | 0 | | |
9 | PA3233 | HR Master Record: Infotype 3233 | 25 | RUNDT | Date of payroll run | nvarchar | 8 | 0 | | |
10 | T5AB0 | Sick Leave Certificate: ELDA Opening and Closing Record | 4 | RUNDT | System Date | nvarchar | 8 | 0 | | |
TOPCanada |
11 | T5KR0 | Record of Employment (ROE) History | 8 | RUNDT | ROE run date | nvarchar | 8 | 0 | | |
12 | T5KSN | ROE Serial Number | 11 | RUNDT | Date Issued (Report Run Date) | nvarchar | 8 | 0 | | |
13 | T5KYA | Year end reporting history table | 5 | RUNDT | Date of payroll run | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
14 | DFKKORDERHIST | Requests: Document History | 10 | RUNDT | Date ID | nvarchar | 8 | 0 | | |
15 | DFKKORDOPHIST | Standing Requests: Document History | 10 | RUNDT | Date ID | nvarchar | 8 | 0 | | |
TOPFinland |
16 | T7FILIS | Table for Low Income Support Statement | 14 | RUNDT | Start date of payroll period (FOR period) | nvarchar | 8 | 0 | | |
TOPIntercompany Data Exchange |
17 | IUEEDPPLOTATADM | Distribute Aggregated Payments: Parameter/Status Management | 4 | RUNDT | Distribute Aggregated Payments from Bill Issuing: Run Date | nvarchar | 8 | 0 | | |
18 | IUEEDPPLOTATADM1 | Distribute Aggr. Payments: Parameter Mgt: Sel. Options | 4 | RUNDT | Distribute Aggregated Payments from Bill Issuing: Run Date | nvarchar | 8 | 0 | | |
19 | IUEEDPPLOTATHEAD | Distribution Lot Header | 4 | RUNDT | Distribute Aggregated Payments from Bill Issuing: Run Date | nvarchar | 8 | 0 | | |
20 | IUEEDPPLOTATREF | Distr. Aggr. Payments: Ref. btwn MR and Distributed Objects | 7 | RUNDT | Distribute Aggregated Payments from Bill Issuing: Run Date | nvarchar | 8 | 0 | | |
TOPPayroll General Parts |
21 | HRPY_RGDIR | Directory for Payroll Results | 18 | RUNDT | Date of payroll run | nvarchar | 8 | 0 | | |
22 | HRPY_RGDIR_TEMP | Internal TEMPORARY Directory for Payroll Results | 18 | RUNDT | Date of payroll run | nvarchar | 8 | 0 | | |
TOPPublic Sector |
23 | P01ZFA_NN_DATA | ZfA: Notifications Not Assigned | 5 | RUNDT | Run Date | nvarchar | 8 | 0 | | |
TOPReporting |
24 | T5KR4 | Record of Employment (ROE) History for Concurrent Employment | 9 | RUNDT | ROE run date | nvarchar | 8 | 0 | | |
TOPSweden |
25 | T5SPP | HR-SE: Information needed to be reported to Alecta | 6 | RUNDT | HR-SE: Date of report run | nvarchar | 14 | 0 | | |
TOPTax Reporter |
26 | T5UQR | Cross quarter retro-calculations | 6 | RUNDT | Generation Date | nvarchar | 8 | 0 | | |