| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | FECIN | ANSES census record issue date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | CLAVE | Code for identifying if employee or fam. member/next of kin | char | 1 | 0 | | | | Allow NULL? |
| 6 | SUBTY | Subtype | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | OBJPS | Object Identification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | NOVED | Type of update | char | 1 | 0 | | | | Allow NULL? |
| 9 | CUILC | Worker identification number (CUIL) (11 characters) | nvarchar | 11 | 0 | | | | Allow NULL? |
| 10 | APELC | Married last name | nvarchar | 28 | 0 | | | | Allow NULL? |
| 11 | APELL | Last name | nvarchar | 28 | 0 | | | | Allow NULL? |
| 12 | NOMBS | Names | nvarchar | 28 | 0 | | | | Allow NULL? |
| 13 | TIDOC | ANSes Census document type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | NUDOC | Document number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | FENAC | Date of birth | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | CSEXO | Gender of employee/family member | char | 1 | 0 | | | | Allow NULL? |
| 17 | CALLE | Street | nvarchar | 30 | 0 | | | | Allow NULL? |
| 18 | NUMER | Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | NPISO | Floor | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | DEPAR | Office or department | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | LOCAL | Town | nvarchar | 28 | 0 | | | | Allow NULL? |
| 22 | CODPO | Postal code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | CODPR | ANSes Census province code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | NACIO | ANSeS Census nationality code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | CIVIL | ANSeS census marital status | char | 1 | 0 | | | | Allow NULL? |
| 26 | DISCA | Disability named person/family member | char | 1 | 0 | | | | Allow NULL? |
| 27 | FRELE | Date of substitution | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | CODPA | Family relationship code | char | 1 | 0 | | | | Allow NULL? |
| 29 | CBAJA | Leaving code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | OBRAS | Welfare Fund code | nvarchar | 6 | 0 | | | | Allow NULL? |
| 31 | FALTI | Employment entry date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | SIREV | Review situation - ANSES Census | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | DOMEX | Business address code | nvarchar | 6 | 0 | | | | Allow NULL? |
| 34 | ECUIT | Taxpayer Identification Number (CUIT) (11 characters) | nvarchar | 11 | 0 | | | | Allow NULL? |
| 35 | FCUIL | Worker identification number (CUIL) (11 characters) | nvarchar | 11 | 0 | | | | Allow NULL? |
| 36 | GENAF | Generate entitlement to Family allowance | char | 1 | 0 | | | | Allow NULL? |
| 37 | ESCOL | Schooling | char | 1 | 0 | | | | Allow NULL? |
| 38 | CUANO | Current year | char | 1 | 0 | | | | Allow NULL? |
