GPCH_AUDT_DSHBR

(SQL Table)
 Index Back

GPCH Audit - XML Manager

Audit XML Manager

  • Related Language Record: GPCH_AUDSHB_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 GPCH_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL Pay Year
    3 GPCH_EG_RPT_TYPE Character(1) VARCHAR2(1) NOT NULL Reporting Period
    M=Monthly
    Q=Quarterly
    Y=Yearly

    Default Value: Y

    4 GPCH_FK_QUARTER Character(1) VARCHAR2(1) NOT NULL Canton select quarterly FAK report
    1=Quarter 1
    2=Quarter 2
    3=Quarter 3
    4=Quarter 4

    Default Value: 1

    5 GPCH_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date

    Prompt Table: GPCH_RP_DATE_VW

    6 GPCH_AUDT_VERSION Number(3,0) SMALLINT NOT NULL Current version of Certificate
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 GPCH_AUDT_FILE_ID1 Character(128) VARCHAR2(128) NOT NULL GPCH File ID Field

    Prompt Table: GPCH_AUDT_INTVW

    9 GPCH_AUDT_FILE_ID2 Character(128) VARCHAR2(128) NOT NULL GPCH File ID Field

    Prompt Table: GPCH_AUDT_EXTVW

    10 GPCH_AUDT_SET_MODL Character(3) VARCHAR2(3) NOT NULL Domain Set ID for the ELM Domain Sets

    Prompt Table: GPCH_AUDT_SET

    11 GPCH_AUDT_USE_PRCS Character(1) VARCHAR2(1) NOT NULL Use Precision in Results View

    Y/N Table Edit

    Default Value: N