| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ECPAO_COMPANY | EC Company | 5 | PERSONID | Person ID Mapping | nvarchar | 1 | 0 | | |
2 | HRSFI_D_COMP_ERR | SuccessFactors: Comp Log Table for Errors in Delta Handling | 8 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
3 | HRSFI_D_COMP_EX2 | SuccessFactors: Comp Log Table for Transfer Data (Delta Log) | 5 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
4 | HRSFI_D_COMP_EXT | SuccessFactors: Comp Log Table for Transfer Data (Delta Log) | 4 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
5 | HRSFI_D_COMP_IMP | SuccessFactors: Imported Comp data | 6 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
6 | HRSFI_D_COMP_STA | SuccessFactors: Comp Log Table for Status Information | 8 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
7 | HRSFI_D_ERR_LOG | SuccessFactors: Log Table for Errors in Delta Handling | 5 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
8 | HRSFI_D_EXTR_LOG | SuccessFactors: Log Table for Delta Handling | 4 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
9 | HRSFI_D_INACT_EE | SuccessFactors: Log for Inactive Employees | 4 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
10 | HRSFI_D_VARPY_ER | SuccessFactors: Variable Pay Log Table for Errors | 9 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
11 | HRSFI_D_VARPY_EX | SuccessFactors: Variable Pay Log Table for Transferred Data | 9 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
12 | HRSFI_D_VARPY_IM | Imported Variable Pay data | 6 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
13 | HRSFI_D_VARPY_ST | Variable Pay Log Table for Status Information | 8 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
14 | PYC_D_PY_MSG | PYC: payroll message | 19 | PERSONID | External Person ID | nvarchar | 20 | 0 | | |
15 | T77TMCPIC_URLS | Buffer for Photo URLs | 2 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
TOPStrategic Enterprise Management |
16 | HRPERSONEE | Linking Employee / Central Person | 3 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |
TOPTax Reporter |
17 | T5UX1 | Tax Reporter Employee Index | 6 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | | |