GPAU_RC_LVELIAB

(SQL Table)
 Index Back

Run Cntl - Leave Liab Rpt AUS

This table will be used to record the parameters for running the GP AUS Liability report program. The key fields for this table include the operator ID and run control ID.

  • Parent Record Of GPAU_RC_LL_ABCT GPNZ_RC_LL_ABCT

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

    Default Value: PRCSRUNCNTL.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: PRCSRUNCNTL.RUN_CNTL_ID

    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

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

    Prompt Table: GP_PYENT

    5 ASOFDATE Date(10) DATE NOT NULL As of Date

    Default Value: %Date

    6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

    Prompt Table: GP_PYGRP_OPR_VW

    7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL_ACCESS

    8 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
    A=All Countries
    C=Specific Country

    Default Value: C

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

    Default Value: AUS