Table SITEPAYE
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| SITEPAYE | SIT | Sites | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SIT0 | FCY | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AEMFCY | MEC site | FCY | [FCY]FCY0=[SIT]AEMFCY | Block | ||||
| AEMFLG | MEC site | M | 5 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BPADCL | Declaring site address | ADR | PAY | |||||
| BPASGE | Headquarters address | ADR | PAY | |||||
| CCSFCY | CECS site | FCY | [FCY]FCY0=[SIT]CCSFCY | Block | ||||
| CCSFLG | CECS site | M | 4 | 1 | ||||
| CHEF | Supervisors | 20 | MAT | [ID]ID0=[SIT]CHEF | RTZ | |||
| CLLCVT | Collective agreement | ADI | [ADI]CODE=358;CLLCVT | Block | PAY | |||
| CNTDDS | TDS contact | AIN | [AIN]AIN0=[SIT]CNTDDS | Block | PAY | |||
| CODCRA | CRAM code | A | 20 | PAY | ||||
| CPA | Working day AL | TPS | [TIM]TIM0=[SIT]CPA | Block | TPS | |||
| CPE | Weekday AL | TPS | [TIM]TIM0=[SIT]CPE | Block | TPS | |||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| DADFCY | DAS2 site | FCY | [FCY]FCY0=[SIT]DADFCY | Other | PAY | |||
| DADFLG | DAS2 | M | 4 | 1 | PAY | |||
| DAYMAXYEA | Maxi days per year | DCB | 4.2 | TPS | ||||
| FCY | Site | FCY | [FCY]FCY0=[SIT]FCY | Delete | ||||
| FLGAPP | Apprenticeship tax | C | 4 | FPAY | ||||
| FLGFOR | Prof. training | C | 4 | FPAY | ||||
| FLGLAB | Contractor label | M | 4 | 1 | ||||
| FLGLIC | Entertainment license | M | 4 | 1 | ||||
| FLGOCC | Occasional | M | 4 | 1 | ||||
| FLGPEC | Housing levy | C | 4 | FPAY | ||||
| NUMASS | ASSEDIC number | A | 9 | |||||
| NUMCCS | Entertainment Fund no. | A | 10 | |||||
| NUMLAB | Label number | A | 3 | |||||
| NUMLIC | License number | A | 10 | |||||
| PAYFLG | Payroll | M | 4 | 1 | PAY | |||
| PRF | Profile | PRF | [PRF]PRF0=[SIT]PRF | Block | ||||
| REGPRH | Industrial tribunal scheme | M | 15 | 373 | PAY | |||
| RSKWRK | Risk | VAC | [WAC]WAC0=[SIT]RSKWRK | Block | PAY | |||
| SECPRH | Derogation polling subdivision | M | 15 | 373 | ||||
| SRV | Department | SRV | [SRV]SRV0=[SIT]SRV | Block | ||||
| TAXWAG | Tax/salaries | C | 4 | FPAY | ||||
| TREFCY | Delivery location code | A | 10 | FTRH | ||||
| TREFCY2 | Site code | A | 10 | FCQH | ||||
| TYPSAL | Remuneration type | C | 4 | FPAY | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |