ESTAB_TBL_FRA

(SQL Table)
Index Back

Establishment Table - France

Establishment table for French Localizations

  • Parent record: ESTAB_TBL
  • # 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
    Set Control Field: REG_REGION

    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

    Prompt Table: CRAM_TBL
    Set Control Field: CRAM_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