Table TASSEDIC
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| TASSEDIC | ATS | Pôle Emploi certificate | Payroll |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| ATS0 | REFNUM+XITDAT+CTRNUM | No | |
| ATS1 | XITDAT+REFNUM+CTRNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD1 | Address | ADL | ||||||
| ADD2 | Address | ADL | ||||||
| ADD3 | Address | ADL | ||||||
| ALCLEA | AL benefits | DCB | 9.2 | |||||
| ALCNTC | Notice payment | DCB | 9.2 | |||||
| AMTALC | Allowance amount | 19 | DCB | 9.2 | ||||
| AMTALLCLE | Full settlement | DCB | 9.2 | |||||
| AMTBNS | Amount of paid bonus | 20 | DCB | 9.2 | ||||
| AMTCLE | Amount | DCB | 9.2 | |||||
| AMTDIF | Amount | DCB | 9.2 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BNSSTG | Bonuses | DCB | 9.2 | |||||
| BUL | Payslip | VCR | ||||||
| CAIAGI | AGIRC | A | 200 | |||||
| CAIARC | ARRCO | A | 200 | |||||
| CAIPRO | Prof. fund | A | 30 | |||||
| CAIRETSPE | Other fund | A | 200 | |||||
| CATQLF | Qualification code | ADI | [ADI]CODE=605;CATQLF | Block | ||||
| CIV | Title | M | 15 | 231 | ||||
| CLM1 | Accounts receivable | A | 30 | |||||
| CLM2 | Accounts receivable | A | 30 | |||||
| CODACS | Access code | ACS | [ACS]ACS0=[ATS]CODACS | Block | ||||
| CODANA | Analytical code | A | 4 | |||||
| CODPOS | Postal code | POS | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[ATS]CRY | Block | ||||
| CRYBRN | Country of birth | CRY | [TCY]TCY0=[ATS]CRYBRN | Block | ||||
| CTRNUM | Contract | CTR | ||||||
| CTY | City | CTY | ||||||
| CURCLE | Balance currency | CUR | [TCU]TCU0=[ATS]CURCLE | Block | ||||
| DATADH | Membership date | D | ||||||
| DATBNS | Bonus date | 20 | D | |||||
| DATBRN | Birth date | D | ||||||
| DATNTF | Notification date | D | ||||||
| DATPLNSOC | Collective redundancy program date | D | ||||||
| DATRCV | Resumption date | D | ||||||
| DEPLSTPLC | Department | A | 2 | |||||
| DESBNS | Bonus title | 20 | A | 50 | ||||
| EML | MAI | |||||||
| EMPCTR | Specific contract | ADI | [ADI]CODE=354;EMPCTR | Block | ||||
| EMPCTRSPE | Other employment | A | 30 | |||||
| EMPHRSWEK | Weekly hours | DCB | 3.2 | |||||
| EMPHRSYEA | Yearly hours | DCB | 4.2 | |||||
| EMPQLY | Employment quality | M | 15 | 312 | ||||
| EMPQLYSPE | Other quality | A | 30 | |||||
| EMPSTA | Status | M | 15 | 363 | ||||
| EMPSTASPE | Other status | A | 30 | |||||
| EMPSYSSSC | Rule | ADI | [ADI]CODE=355;EMPSYSSSC | Block | ||||
| ENDDAT | Period end date | D | ||||||
| ENDDATALC | End date | D | ||||||
| ENDDATBNS | Bonus end date | 20 | D | |||||
| ENDDATCLE | Balance end date | D | ||||||
| ENDDATPRV1 | Notice period end date | D | ||||||
| ENDDATPRV2 | Notice period end date | D | ||||||
| ENDDATPRV3 | Notice period end date | D | ||||||
| ENDDATPRV4 | Notice period end date | D | ||||||
| ENDWRK | End date | D | ||||||
| FCY | Site | FCY | [FCY]FCY0=[ATS]FCY | Block | ||||
| FCYADD1 | Address | ADL | ||||||
| FCYADD2 | Address | ADL | ||||||
| FCYADD3 | Address | ADL | ||||||
| FCYCRN | Site tax ID no. | CRT | ||||||
| FCYCRY | Country | CRY | [TCY]TCY0=[ATS]FCYCRY | Block | ||||
| FCYCTY | City | CTY | ||||||
| FCYHRSWEK | Weekly hours | DCB | 3.2 | |||||
| FCYHRSYEA | Yearly hours | DCB | 4.2 | |||||
| FCYNAF | NAF code | NAF | ||||||
| FCYNBRSAL | Workforce | L | 6 | |||||
| FCYPOSCOD | Postal code | POS | ||||||
| FCYRPB | Supervisor | A | 40 | |||||
| FCYRPBFNC | Function | M | 15 | 233 | ||||
| FCYRPBTEL | Telephone | TEL | ||||||
| FCYSGE | Head office | FCY | [FCY]FCY0=[ATS]FCYSGE | Block | ||||
| FCYSTALEG | Legal status | A | 30 | |||||
| FCYTEL | Telephone | TEL | ||||||
| FLGAFR | AFR enlargement | M | 4 | 1 | ||||
| FLGALC | Part-time unemployment | M | 4 | 1 | ||||
| FLGALC14 | Current transaction | M | 4 | 1 | ||||
| FLGALCTOT | Total unemployment | M | 4 | 1 | ||||
| FLGCNG | Redeployment | M | 4 | 1 | ||||
| FLGCVT | Agreement Management | M | 4 | 1 | ||||
| FLGFNG1 | Received | M | 4 | 1 | ||||
| FLGFNG2 | To be drawn | M | 4 | 1 | ||||
| FLGLIKFAM | Kinship | M | 4 | 1 | ||||
| FLGNSS | Self insurance | M | 4 | 1 | ||||
| FLGPORMUT | Compl health portability | M | 4 | 1 | ||||
| FLGPORPRV | Welfar portability | M | 4 | 1 | ||||
| FLGPRV | Notice period completed | M | 4 | 1 | ||||
| FLGPRVOFF | Notice period not completed | M | 4 | 1 | ||||
| FLGRVC | Revocable title | M | 4 | 1 | ||||
| FLGVACSPE | Special scheme | M | 4 | 1 | ||||
| GRD1 | Reason | A | 30 | |||||
| GRD2 | Reason | A | 30 | |||||
| GRDHRSSPE | Other reason | A | 30 | |||||
| GRDHRSWEK | Reasons | M | 15 | 366 | ||||
| GRDPRV | Notice period reason | A | 30 | |||||
| GRDXIT | End reasons | ADI | [ADI]CODE=359;GRDXIT | Block | ||||
| GRDXITSPE | Other reason | A | 30 | |||||
| JOBPUB | Public employment | M | 15 | 364 | ||||
| LIBLIKFAM | Kinship | A | 30 | |||||
| LSTDAYWRK | Last day | D | ||||||
| LSTJOB | Last employment | A | 30 | |||||
| LSTPLCWRK | Last place of work | A | 35 | |||||
| NAM | Name | A | 40 | |||||
| NAMSYSSSC | Scheme fund | A | 30 | |||||
| NBRDAYLEA | Number of days | DCB | 3.2 | |||||
| NBRDIF | No. of DIF hours | DCB | 9.2 | |||||
| NBRHRSCLE | No. of hours worked | DCB | 9.2 | |||||
| NBRMON | Number of months | DCB | 9.2 | |||||
| NBRPERSTG | Internship duration | C | 4 | |||||
| NBRWEE | Nb of weeks | DCB | 9.2 | |||||
| NUMCVT | Labor agreement no. | A | 6 | |||||
| NUMFRM | Slip no. | FRM | [FRM]FRM0=[ATS]NUMFRM | Delete | ||||
| NUMORD | Order no. | L | 8 | |||||
| NUMORGASS | Membership no. | A | 17 | |||||
| NUMSSC | Social Security | SSE | ||||||
| NUMSYSSSC | Scheme no. | A | 15 | |||||
| OLDNAM | Birth name | A | 40 | |||||
| ORGASS | Affiliation | M | 15 | 325 | ||||
| ORGASSSPE | Other membership | A | 30 | |||||
| ORGDIF | Collecting body | A | 10 | |||||
| PERSTG | Period | M | 15 | 313 | ||||
| PLNSOC | Collective redundancy program | M | 4 | 1 | ||||
| PYRDATCLE | Payment date | D | ||||||
| QLF | Qualification | A | 30 | |||||
| REFNUM | Employee ID | MAT | [ID]ID0=[ATS]REFNUM | Delete | ||||
| REJCVTFNE | FNE agreement rejection | M | 4 | 1 | ||||
| RGMSPESSC | SS scheme extension | C | 4 | FPAY | ||||
| RPBCTY | Signature place | A | 30 | |||||
| RPBDAT | Signature date | D | ||||||
| RPBFNCSPE | Other function | A | 30 | |||||
| SALGROCLE | Gross salary | DCB | 9.2 | |||||
| SCHNAM | Establishment | A | 50 | |||||
| SRN | Employee's first name | A | 40 | |||||
| STA | Status | ADI | [ADI]CODE=364;STA | Block | ||||
| STRDAT | Period start date | D | ||||||
| STRDATALC | Start date | D | ||||||
| STRDATBNS | Bonus start date | 20 | D | |||||
| STRDATCLE | Balance start date | D | ||||||
| STRDATPRV1 | Notice period start date | D | ||||||
| STRDATPRV2 | Notice period start date | D | ||||||
| STRDATPRV3 | Notice period start date | D | ||||||
| STRDATPRV4 | Notice period start date | D | ||||||
| STRWRK | Start date | D | ||||||
| TEL | Telephone | TEL | ||||||
| TYPLNK | Kinship | M | 30 | 2524 | ||||
| TYPSCH | Course studies | A | 50 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 | |||||
| XITDAT | Issue date | D |