PG_HDR_00_EC

(SQL Table)
 Index Back

Pell Header Staging Table 00

  • Parent Record Of PG_DSBACK_00_EC PG_MRR_00_EC PG_ORGACK_00_EC PG_ORIG_00_EC PG_SDBACK_00_EC PG_SDSB_00_EC PG_TRLR_00_EC SFA_ASG_MRR_EC SFA_ASG_TRLR_EC SFA_PG_TRL_DOD SFA_PG_TRL_GRNT SFA_PG_TRL_LEU

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
    2 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
    3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
    I=Inbound
    O=Outbound
    4 PG_HEADER_ID Character(10) VARCHAR2(10) NOT NULL Pell Header ID

    Default Value: GRANT HDR

    5 PG_RECORD_LENGTH Character(4) VARCHAR2(4) NOT NULL Pell Record Length
    6 PG_BATCH_ID_00 Character(26) VARCHAR2(26) NOT NULL Pell Batch ID
    7 PG_GRANTEE_DUNS Character(9) VARCHAR2(9) NOT NULL Pell Grantee DUNS Num
    8 PG_SERVICER_DUNS Character(9) VARCHAR2(9) NOT NULL Pell FA Servicer DUNS
    9 PG_SERVICER_NBR Character(2) VARCHAR2(2) NOT NULL Pell FA Servicer Nbr
    10 PG_MEDIA_TYPE Character(1) VARCHAR2(1) NOT NULL Pell Media Type
    11 PG_RFMS_PROC_DT Character(8) VARCHAR2(8) NOT NULL Pell RFMS Process Dt
    12 PG_BATCH_RJCT_1 Character(3) VARCHAR2(3) NOT NULL Pell Batch Reject 1
    13 PG_BATCH_RJCT_2 Character(3) VARCHAR2(3) NOT NULL Pell Batch Reject 2
    14 PG_BATCH_RJCT_3 Character(3) VARCHAR2(3) NOT NULL Pell Batch Reject 3
    15 PG_BATCH_RJCT_4 Character(3) VARCHAR2(3) NOT NULL Pell Batch Reject 4
    16 PG_BATCH_RJCT_5 Character(3) VARCHAR2(3) NOT NULL Pell Batch Reject 5
    17 PG_BATCH_RJCT_6 Character(3) VARCHAR2(3) NOT NULL Pell Batch Reject 6
    18 PG_BATCH_RJCT_7 Character(3) VARCHAR2(3) NOT NULL Pell Batch Reject 7
    19 PG_BATCH_RJCT_8 Character(3) VARCHAR2(3) NOT NULL Pell Batch Reject 8
    20 PELL_TRANS_DTTM DateTime(26) TIMESTAMP Pell Trans Date/Time
    21 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    22 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    23 PG_OPE_ID_NBR Character(8) VARCHAR2(8) NOT NULL OPE ID Number
    24 PG_SOFTWARE_ID Character(10) VARCHAR2(10) NOT NULL Software Provider ID