| # |
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 #
|
| 11 |
ASSEDIC_NM_FRA |
Character(20) |
VARCHAR2(20) NOT NULL |
ASSEDIC #
|
| 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
|