GPCH_EG_PSTATUS

(SQL Table)
 Index Back

ELM Reciever File Status

GPCH:ELM Reciever File Status

  • Parent Record Of GPCH_EG_DLGRSP

    • # 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_SI_PROV_TYPE Character(1) VARCHAR2(1) NOT NULL Provider Type
    0=Identify
    1=Others
    2=UVG-LAA
    3=KTG-AMC
    4=UVGZ-LAAC
    5=FAK-CAF
    6=BVG-LPP
    7=AHV-AVS
    8=LAW-CDS
    9=BFS-OFS
    A=QST-IS
    B=Write File
    C=Base AL08
    D=GRFI-FRFI
    E=EO-APG
    I=BNK_BNQ
    6 GPCH_SI_PROV_CD Character(6) VARCHAR2(6) NOT NULL Provider Code
    7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    8 GPCH_EG_USERKEY Character(2) VARCHAR2(2) NOT NULL GPCH ELM Userkey to Specify Canton
    9 GPCH_EG_RESPONSEID Character(30) VARCHAR2(30) NOT NULL Response ID for ELM
    10 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
    11 GPCH_EG_COMPLETE Character(1) VARCHAR2(1) NOT NULL GPCH ELM Complete Flag

    Y/N Table Edit

    Default Value: N

    12 FILE_DATA_CHAR Long Character(32000) CLOB File Data
    13 GPCH_EG_SNT_TIME DateTime(26) TIMESTAMP GPCH:ELM File Sent TimeStamp
    14 GPCH_EG_RCV_TIME DateTime(26) TIMESTAMP Time at which the ELM file is Recieved
    15 GPCH_EG_RESEND Character(1) VARCHAR2(1) NOT NULL GPCH ELM Flag for Resend

    Y/N Table Edit

    Default Value: N

    16 GPCH_EG_REQID_OLD Character(30) VARCHAR2(30) NOT NULL Old Request ID for ELM
    17 GPCH_EG_RESPID_OLD Character(30) VARCHAR2(30) NOT NULL Old Response Id for ELM file
    18 GPCH_EG_JOBKEY Character(30) VARCHAR2(30) NOT NULL Jobkey
    19 GPCH_EG_DECL_ID Character(30) VARCHAR2(30) NOT NULL Declaration ID
    20 GPCH_RESULT_FLAG Character(14) VARCHAR2(14) NOT NULL Get Result Flag
    21 GPCH_GETDLG_FLAG Character(14) VARCHAR2(14) NOT NULL Get Dialog Status
    22 GPCH_REPDLG_FLAG Character(14) VARCHAR2(14) NOT NULL Get Result Flag
    23 GPCH_RESULTSYN_FLG Character(14) VARCHAR2(14) NOT NULL Get Result Sync. Flag
    24 GPCH_COMPL_STATUS Character(4) VARCHAR2(4) NOT NULL Completion Status
    0001=With Completion
    0002=Without Completion
    0003=Completion Release Missing
    0004=DialogAndResult