GPFR_ASS_RUNCTL

(SQL Table)
 Index Back

Run control ASSEDIC Certif

Run control ASSEDIC Certif. Used in the retrieval of datas so as to full fill and print the ASSEDIC Certificate.

  • Related Language Record: GPFR_ASS_RU_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPERATOR_VW

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

    Prompt Table: GPFR_CAL_RUN_VW

    4 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

    Prompt Table: GPFR_ASS_PAY_S

    5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_VW

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 GPFR_ILL_NAME Character(50) VARCHAR2(50) NOT NULL GPFR: Name of the Signatory
    8 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
    9 GPFR_ASS_SIGN_STAT Character(30) VARCHAR2(30) NOT NULL GPFR: Other Status of the Signatory
    10 GPFR_ASS_PLACE_SIG Character(30) VARCHAR2(30) NOT NULL GPFR: Place for Signature
    11 GPFR_ASS_SIG_DATE Date(10) DATE GPFR: Date of Signature

    Default Value: %date

    12 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    13 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    14 GPFR_ASS_RESP_FOR Character(30) VARCHAR2(30) NOT NULL GPFR: Person Responsible for Certif