| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPSocial Services and Social Security |
1 | PSSCD_GEDITEM | Gross Entitlement Determination Item Data | 7 | BENEFIT_ID | Benefit ID | varbinary | 16 | 0 | | |
2 | PSSCD_GPDITEM | Gross Payment Docment Item Data | 11 | BENEFIT_ID | Internal Unique ID of Product | varbinary | 16 | 0 | | |
3 | PSSCD_NCDITEM | Net Calculation Document Item | 9 | BENEFIT_ID | Benefit ID | varbinary | 16 | 0 | | |
TOPWorkforce Management Application |
4 | WFA_SCHE_BENF | Actual imported benefits table | 2 | BENEFIT_ID | Benefit Id | nvarchar | 32 | 0 | | |
TOPWorkforce Management Core |
5 | WFMCAS_SCHE_BENF | Actual imported benefits table | 2 | BENEFIT_ID | Benefit Id | nvarchar | 32 | 0 | | |