ESTAB_TBL_FRA(SQL Table) |
Index Back |
---|---|
Establishment Table - FranceEstablishment table for French Localizations |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
3 | TRANSPORT_RT2_FRA | Number(19,6) | DECIMAL(18,6) NOT NULL | DUCS Additional Transport Rate |
4 | TRS_RATE_DT_FRA | Date(10) | DATE | DUCS Transport Rate Date |
5 | TAT_RATE_DT_FRA | Date(10) | DATE | DUCS Additional Transport Rate Date |
6 | SIREN_CD_FRA | Character(9) | VARCHAR2(9) NOT NULL |
SIREN Code
Default Value: COMPANY_TBL.SIREN_CD_FRA |
7 | NIC_CODE_FRA | Character(5) | VARCHAR2(5) NOT NULL | NIC Code |
8 | APE_INDSTRY_CD_FRA | Character(5) | VARCHAR2(5) NOT NULL |
APE Code
Default Value: COMPANY_TBL.APE_INDSTRY_CD_FRA Prompt Table: APE_INDSTRY_FRA |
9 | URSSAF_CD_FRA | Character(4) | VARCHAR2(4) NOT NULL |
URSSAF Code (FRA)
Prompt Table: URSSAF_TBL_FRA |
10 | URSSAF_NM_FRA | Character(20) | VARCHAR2(20) NOT NULL | URSSAF Number |
11 | ASSEDIC_NM_FRA | Character(20) | VARCHAR2(20) NOT NULL | ASSEDIC Number |
12 | ANNUAL_REPORT_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Annual Report Declaration
Y/N Table Edit Default Value: Y |
13 | LABOR_AGREEMENT | Character(6) | VARCHAR2(6) NOT NULL |
Labor Agreement
Default Value: COMPANY_TBL.LABOR_AGREEMENT Prompt Table:
EMPL_CTG
|
14 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL |
Bank ID
Prompt Table: BANK_TBL_FRA_VW |
15 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
16 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
17 | CHECK_DIGIT | Character(2) | VARCHAR2(2) NOT NULL | Check Digit |
18 | CRAM_ID | Character(4) | VARCHAR2(4) NOT NULL | CRAM Fund ID |
19 | TDS_DECLARED | Character(1) | VARCHAR2(1) NOT NULL |
TDS Declared Establishment
Y/N Table Edit Default Value: Y |
20 | TDS_ESTABID | Character(5) | VARCHAR2(5) NOT NULL | Declared Establishment |
21 | TRANSPORT_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Transport Rate |
22 | BASE_SCHEME_FRA | Character(3) | VARCHAR2(3) NOT NULL |
Mandatory Base Scheme
Prompt Table: BSE_SCH_FRA_TBL |
23 | LIABILITY_TAX_FRA | Character(2) | VARCHAR2(2) NOT NULL |
Tax on Salary Liability - FRA
01=Yes 02=No |
24 | ESTAB_ACTIVITY_FRA | Character(36) | VARCHAR2(36) NOT NULL | Establishment Activity |
25 | MEDICAL_ORG_FRA_CD | Character(3) | VARCHAR2(3) NOT NULL |
Medical Organism Code - FRA
Prompt Table: MED_ORG_FRA_TBL |
26 | ESTAB_CONTACT_ID | Character(11) | VARCHAR2(11) NOT NULL |
Establishment Contact ID: this employee ID is the contact for his establishment.
Prompt Table: PERS_SRCH_GBL |
27 | FONGECIF_CD_FRA | Character(6) | VARCHAR2(6) NOT NULL |
FONGECIF Code
Prompt Table: TRN2483_VDRFFVW |
28 | GPFR_DA_CLS_DT | Date(10) | DATE | Establishment Close date |
29 | CLOSE_DT_FRA | Date(10) | DATE | Establishment Close date |