GPFR_AT_ADMIN

(SQL Table)
 Index Back

ATMP Admin info.

ATMP Administrative information.

  • Related Language Record: GPFR_AT_ADM_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 ORIG_BEGIN_DT Date(10) DATE original begin date
    4 GPFR_AT_REASON Character(2) VARCHAR2(2) NOT NULL GPFR: Reason for Absence
    AT=Industrial Accident
    MP=Occupational Illness
    5 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    7 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: ESTAB_TBL

    8 GPFR_DESCR1 Character(30) VARCHAR2(30) NOT NULL GPFR: Description
    9 GPFR_ASS_ESTB_DESC Character(30) VARCHAR2(30) NOT NULL GPFR: Establishment
    10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

    24 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    25 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    26 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_OTH

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

    Y/N Table Edit

    43 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    44 GPFR_AT_COUNTRY Character(3) VARCHAR2(3) NOT NULL GPFR: Country - Other

    Prompt Table: COUNTRY_CUR_TBL

    45 GPFR_AT_ADD1 Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    46 GPFR_AT_ADD2 Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    47 GPFR_AT_ADD3 Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    48 GPFR_AT_ADD4 Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    49 GPFR_AT_CITY Character(30) VARCHAR2(30) NOT NULL City Other
    50 GPFR_AT_POSTAL Character(12) VARCHAR2(12) NOT NULL GPFR: Postal Code
    51 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    52 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    53 GPFR_AT_PHONE Character(24) VARCHAR2(24) NOT NULL GPFR: Telephone
    54 SIREN_CD_FRA Character(9) VARCHAR2(9) NOT NULL SIREN Code

    Default Value: COMPANY_TBL.SIREN_CD_FRA

    55 SIRET_CD Character(20) VARCHAR2(20) NOT NULL SIRET
    56 RISKCD Character(6) VARCHAR2(6) NOT NULL Risk Code
    57 NAME Character(50) VARCHAR2(50) NOT NULL Name
    58 HIRE_DT Date(10) DATE First Start Date
    59 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    60 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    61 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    62 SSN_KEY_FRA Character(2) VARCHAR2(2) NOT NULL Social Security Number Key
    63 BIRTHDATE Date(10) DATE Date of Birth
    64 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    65 GPFR_AT_NATIONAL Character(3) VARCHAR2(3) NOT NULL GPFR: Nationality
    EEC=EEC Resident
    FRA=French
    OTH=Other
    66 GPFR_AT_ACCIDEN_DT Date(10) DATE GPFR: Date of the Accident / Illness
    67 LAST_DATE_WORKED Date(10) DATE Last Date Worked
    68 RETURN_DT Date(10) DATE Return Date
    69 EMP_CATEGRY_FRA Character(3) VARCHAR2(3) NOT NULL Employee Category
    CAD=Executive
    ETA=Manager
    OUV=Workman
    70 PROF_EXPERIENCE_DT Date(10) DATE Professional Experience Date
    71 GPFR_AT_OTH_VICTIM Character(1) VARCHAR2(1) NOT NULL GPFR: Are There Other Victims ?

    Y/N Table Edit

    Default Value: N

    72 GPFR_AT_DOCTOR Character(70) VARCHAR2(70) NOT NULL GPFR: Name and Address health Doctor
    73 GPFR_ILL_JOB_RSMPT Character(1) VARCHAR2(1) NOT NULL GPFR: No Work Resumption at this Day

    Y/N Table Edit

    74 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    75 GPFR_ILL_BGN_DT Date(10) DATE GPFR: From Date for the Period
    76 GPFR_ILL_END_DT Date(10) DATE GPFR: Period End Date
    77 GPFR_ILL_SUB_FDT Date(10) DATE GPFR: Beginning of the Subrogation
    78 GPFR_ILL_SUB_TDT Date(10) DATE GPFR: End Date of the Subrogation
    79 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code
    80 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

    Prompt Table: BANK_EC_TBL

    81 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID

    Prompt Table: BANK_BRANCH_TBL

    82 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
    83 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    84 GPFR_BANK_NAME Character(24) VARCHAR2(24) NOT NULL GPFR: Receiver's Bank Name
    85 GPFR_ILL_EURO_1 Character(1) VARCHAR2(1) NOT NULL GPFR: Payment in Euro

    Y/N Table Edit

    86 GPFR_AT_UPHOLD_YN Character(1) VARCHAR2(1) NOT NULL GPFR: Upholding the Salary

    Y/N Table Edit

    Default Value: N

    87 GPFR_AT_UPHOLD_2 Character(1) VARCHAR2(1) NOT NULL GPFR: Upholding of the Salary
    I=Integral Upholding
    P=Partial Upholding
    88 GPFR_AT_MINI_WAGE Character(30) VARCHAR2(30) NOT NULL GPFR: Minimum Wage of Apprentices
    89 GPFR_AT_NCONT_DT Character(30) VARCHAR2(30) NOT NULL GPFR: Contract Number and Date
    90 GPFR_AT_UPHOLD Character(1) VARCHAR2(1) NOT NULL GPFR: Upholding of the Salary
    I=Integral Upholding
    P=Partial Upholding
    91 GPFR_ILL_NAME Character(50) VARCHAR2(50) NOT NULL GPFR: Name of the Signatory
    92 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
    93 GPFR_ASS_SIGN_STAT Character(30) VARCHAR2(30) NOT NULL GPFR: Other Status of the Signatory
    94 GPFR_ASS_PLACE_SIG Character(30) VARCHAR2(30) NOT NULL GPFR: Place for Signature
    95 GPFR_ASS_SIG_DATE Date(10) DATE GPFR: Date of Signature

    Default Value: %date

    96 GPFR_ILL_OVER Character(1) VARCHAR2(1) NOT NULL This flag indicates if the extracted data (with the GPFR_ILL_AE Application Engine) has been overwritten (with the page GPFR_ILLNESS_1, 2, ...).

    Y/N Table Edit

    Default Value: N

    97 GPFR_AT_ID_PRINTED Character(1) VARCHAR2(1) NOT NULL GPFR: Printing Already Requested.

    Y/N Table Edit

    Default Value: N

    98 GPFR_AT_DATA_FLAG Character(1) VARCHAR2(1) NOT NULL GPFR: Retrieve this Emplid's Data

    Y/N Table Edit

    Default Value: N

    99 BGN_DT Date(10) DATE Begin Date
    100 END_DT Date(10) DATE end date