| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRDCT_TPY_RGDIR | Declustering - Directory for Test Payroll Results | 31 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | |
2 | HRP1661 | DB Table for Infotype 1661 | 18 | OCCAT | Occupational Category | nvarchar | 1 | 0 | | |
3 | P2RX_VERSC | Payroll Status Information | 34 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | |
4 | T5GPBSH13 | HESA: Occupational categories for HE jobs | 6 | OCCAT | HESA: Occupational categorie, activity code | nvarchar | 2 | 0 | | |
5 | T5GPBSH_OCC | HESA: Occupational categories | 2 | OCCAT | HESA: Occupational categorie, activity code | nvarchar | 2 | 0 | | |
6 | T5GPBSH_OCCT | HESA: Occupational categories (text) | 3 | OCCAT | HESA: Occupational categorie, activity code | nvarchar | 2 | 0 | | |
7 | T5UPBSOCCAT | US Federal Occupational Categories | 2 | OCCAT | Occupational Category | nvarchar | 1 | 0 | | |
8 | T5UPBSOCCATT | US Federal Occupational Category Texts | 3 | OCCAT | Occupational Category | nvarchar | 1 | 0 | | |
9 | T5UPBSOCCSE | US Federal Occupations (Series) | 2 | OCCAT | Occupational Category | nvarchar | 1 | 0 | | |
10 | T5UPBSOCCSET | US Federal Occupation (Series) Texts | 3 | OCCAT | Occupational Category | nvarchar | 1 | 0 | | |
TOPArgentina |
11 | T7AR28 | Assignment of SIJP periods to settled payrolls | 12 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | |
TOPBrazil |
12 | T7BRG1 | Alimony: calculation models | 4 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | |
TOPJapan |
13 | T5J69 | HR Attributes to SYOYO payroll run JP | 10 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | |
TOPOff-Cycle |
14 | T52OCC | Categories for Off-Cycle Reasons | 2 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | |
15 | T52OCCT | Categories for off-cycle reasons - texts | 3 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | |
16 | T52OCR | Reasons for Off-Cycle Payroll Runs | 3 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | |
TOPPayroll |
17 | T7UAADP | | 11 | OCCAT | | nvarchar | 2 | 0 | | |
TOPPayroll General Parts |
18 | HRPY_RGDIR | Directory for Payroll Results | 29 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | |
19 | HRPY_RGDIR_TEMP | Internal TEMPORARY Directory for Payroll Results | 29 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | |
TOPReuse Services for Country Development |
20 | T5JOCC | Payroll Category for Payroll Reason | 1 | OCCAT | Category for off-cycle reason | nvarchar | 2 | 0 | | |
TOPSouth Africa |
21 | HRP1633 | DB Table for Infotype 1633 | 19 | OCCAT | Occupational Category Employment Equity | nvarchar | 4 | 0 | | |
22 | T5W13 | Link job category occupational level Employment equity. | 3 | OCCAT | Occupational Category Employment Equity | nvarchar | 4 | 0 | | |
23 | T5W15 | Job to SOC Code Allocation (South Africa) | 5 | OCCAT | Occupational Category Employment Equity | nvarchar | 4 | 0 | | |