GPFR_ASS_COMP

(SQL Table)
 Index Back

Company Informations

Company Informations. Used in the retrieval of datas so as to full fill and print the ASSEDIC Certificate

  • Related Language Record: GPFR_ASS_CP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    5 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    6 LAST_DATE_WORKED Date(10) DATE Last Date Worked
    7 GPFR_ASS_OVER_IND Character(1) VARCHAR2(1) NOT NULL GPFR: Override Employer's infos

    Y/N Table Edit

    Default Value: Y

    8 GPFR_ASS_PRINT_IND Character(1) VARCHAR2(1) NOT NULL GPFR: Printing Already Requested

    Y/N Table Edit

    Default Value: N

    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 GPFR_ASS_ESTB_DESC Character(30) VARCHAR2(30) NOT NULL GPFR: Establishment
    11 DEFAULT_SETID Character(5) VARCHAR2(5) NOT NULL Default SetID

    Default Value: COMPANY_TBL.COMPANY

    Prompt Table: SETID_TBL

    12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: SET_LOC_VW

    13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    15 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    16 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    17 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    18 CITY Character(30) VARCHAR2(30) NOT NULL City
    19 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    20 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    21 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    22 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    23 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    24 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    25 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    26 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    27 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    28 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    29 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    30 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Prompt Table: COUNTRY_TBL

    31 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    32 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    33 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    34 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    35 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
    36 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    37 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: STATE_OTH

    38 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    39 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    40 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    41 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    42 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
    43 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
    44 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
    45 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other

    Y/N Table Edit

    46 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    47 GPFR_ASS_FND_DESCR Character(30) VARCHAR2(30) NOT NULL GPFR: Description of the Fund
    48 GPFR_ASS_JURI_STS Character(30) VARCHAR2(30) NOT NULL GPFR: Juridic Status
    49 SIREN_CD_FRA Character(9) VARCHAR2(9) NOT NULL SIREN Code

    Default Value: COMPANY_TBL.SIREN_CD_FRA

    50 NIC_CODE_FRA Character(5) VARCHAR2(5) NOT NULL NIC Code
    51 SIRET_CD Character(20) VARCHAR2(20) NOT NULL SIRET
    52 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

    53 URSSAF_CD_FRA Character(4) VARCHAR2(4) NOT NULL URSSAF Code (FRA)

    Prompt Table: URSSAF_TBL_FRA

    54 URSSAF_NM_FRA Character(20) VARCHAR2(20) NOT NULL URSSAF #
    55 ASSEDIC_NM_FRA Character(20) VARCHAR2(20) NOT NULL ASSEDIC #
    56 GPFR_ASS_SUB_INDIC Character(1) VARCHAR2(1) NOT NULL GPFR: Indicator of subscription
    A=ASSEDIC
    G=GARP
    O=Other
    57 GPFR_ASS_NBR_EMPL Number(6,0) INTEGER NOT NULL GPFR: Nbr of Employees at past 12/31
    58 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    59 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    60 GPFR_ILL_NAME Character(50) VARCHAR2(50) NOT NULL GPFR: Name of the Signatory
    61 GPFR_ASS_SIGN_STS Character(2) VARCHAR2(2) NOT NULL Status of the person who will sign the certificate
    01=Managing Director
    02=Manager
    03=Director
    04=Personnel Manager
    05=Accountant
    06=Receiver
    07=Compulsory Liquidator
    08=Other
    62 GPFR_ASS_SIGN_STAT Character(30) VARCHAR2(30) NOT NULL GPFR: Other Status of the Signatory
    63 GPFR_ASS_PLACE_SIG Character(30) VARCHAR2(30) NOT NULL GPFR: Place for Signature
    64 GPFR_ASS_SIG_DATE Date(10) DATE GPFR: Date of Signature

    Default Value: %date

    65 GPFR_ASS_DISS_DESC Character(30) VARCHAR2(30) NOT NULL GPFR: Reason for Breach
    66 GPFR_ASS_RESP_FOR Character(30) VARCHAR2(30) NOT NULL GPFR: Person Responsible for Certif
    67 GPFR_AT_PHONE Character(24) VARCHAR2(24) NOT NULL GPFR: Telephone