GPCH_EG_FSTATUS

(SQL Table)
 Index Back

ELM Internal XML File Status

GPCH-ELM Internal XML File Status

  • Parent Record Of GPCH_XP_EMPLID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 GPCH_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL Pay Year
    3 GPCH_EG_DOMAINID Number(3,0) SMALLINT NOT NULL Domain Set ID for the ELM Domain Sets
    4 GPCH_EG_REQUEST_ID Character(30) VARCHAR2(30) NOT NULL Holds Request ID in the ELM File
    5 GPCH_EG_RESPONSEID Character(30) VARCHAR2(30) NOT NULL Response ID for ELM
    6 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
    7 TIME_STAMP DateTime(26) TIMESTAMP Time Stamp
    8 GPCH_REPORT_STATUS Character(4) VARCHAR2(4) NOT NULL Report Status for Year End Process
    0001=Success
    0002=Accepted
    0003=Warning
    0004=Error
    0005=Soap Fault
    0006=Fault
    0007=Ignored
    0008=Open
    0009=N
    0010=File Error
    0011=Processing
    0012=Completion Release Missing
    9 FILE_DATA_CHAR Long Character(32000) CLOB File Data
    10 GPCH_EG_REQID_OLD Character(30) VARCHAR2(30) NOT NULL Old Request ID for ELM
    11 GPCH_EG_RESPID_OLD Character(30) VARCHAR2(30) NOT NULL Old Response Id for ELM file
    12 GPCH_EG_JOBKEY Character(30) VARCHAR2(30) NOT NULL Jobkey
    13 GPCH_EG_DECL_ID Character(30) VARCHAR2(30) NOT NULL Declaration ID
    14 GPCH_SEND_FLAG Character(14) VARCHAR2(14) NOT NULL Send Flag
    15 GPCH_GETSTATUS_FLG Character(14) VARCHAR2(14) NOT NULL GetStatus Flag
    16 GPCH_SENDSYN_FLAG Character(14) VARCHAR2(14) NOT NULL Send Sync. Flag
    17 GPCH_STATUSSYN_FLG Character(14) VARCHAR2(14) NOT NULL Get Status Sync. Flag
    18 GPCH_MAX_MIN_IND Character(1) VARCHAR2(1) NOT NULL Max Min Indicator
    19 GPCH_EG_SORT_1 Character(1) VARCHAR2(1) NOT NULL Sort Criteria 1.
    C=Residence Canton
    E=Emplid
    F=Firstname
    G=Language
    L=Lastname
    20 GPCH_EG_SORT_2 Character(1) VARCHAR2(1) NOT NULL Sort Criteria 2.
    C=Residence Canton
    E=Emplid
    F=Firstname
    G=Language
    L=Lastname
    21 GPCH_EG_SORT_3 Character(1) VARCHAR2(1) NOT NULL Sort Criteria 3.
    C=Residence Canton
    E=Emplid
    F=Firstname
    G=Language
    L=Lastname