PG_SDBACK_00_EC

(SQL Table)
Index Back

Pell Spec Disb Ackn Staging

  • Parent record: PG_HDR_00_EC
  • # 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_ORIGINATION_ID Character(23) VARCHAR2(23) NOT NULL Pell Origination ID
    5 PG_DISB_REF_NBR Character(2) VARCHAR2(2) NOT NULL Disbursement Reference Nbr
    6 PELL_ORIG_SEQ_NBR Number(2,0) SMALLINT NOT NULL Pell Origination Sequence Nbr
    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    8 PG_ACTION_CODE Character(1) VARCHAR2(1) NOT NULL Action Code
    9 PG_DISB_AMOUNT Character(7) VARCHAR2(7) NOT NULL Disbursement Amount
    10 PG_DEBIT_CREDIT Character(1) VARCHAR2(1) NOT NULL Debit/Credit Indicator
    11 PG_DISB_DT Character(8) VARCHAR2(8) NOT NULL Disbursement Date
    12 PG_PAYPER_NBR Character(1) VARCHAR2(1) NOT NULL Pay Period Number
    13 PG_PAYPER_START_DT Character(8) VARCHAR2(8) NOT NULL Pay Period Start Dt
    14 PG_PAYPER_END_DT Character(8) VARCHAR2(8) NOT NULL Pay Period End Dt
    15 PG_NBR_PAY_PERIODS Character(1) VARCHAR2(1) NOT NULL Number of Payment Periods
    16 PG_PAYPER_AMOUNT Character(7) VARCHAR2(7) NOT NULL Pay Period Amount
    17 PG_PAYPER_ACAD_CAL Character(1) VARCHAR2(1) NOT NULL Pay Period Acad Calendar
    18 PG_PAYPER_PAY_METH Character(1) VARCHAR2(1) NOT NULL Pay Period Payment Methodology
    19 PG_PAYPER_COA Character(7) VARCHAR2(7) NOT NULL Pay Period COA
    20 PG_PAYPER_ENRL_ST Character(1) VARCHAR2(1) NOT NULL Pay Period Enrollment Status
    21 PG_PAYPER_WEEKS Character(2) VARCHAR2(2) NOT NULL Pay Period Weeks in Calc
    22 PG_WEEKS_ACAD_YEAR Character(2) VARCHAR2(2) NOT NULL Weeks in Prgm Acad Year
    23 PG_PAYPER_HOURS Character(4) VARCHAR2(4) NOT NULL Pay Period Hours
    24 PG_HOURS_ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Hours in Academic Year
    25 PG_YTD_DISB_AMOUNT Character(7) VARCHAR2(7) NOT NULL YTD Disbursed Amount
    26 PG_MSG_CODE_1 Character(3) VARCHAR2(3) NOT NULL Message Code 1
    27 PG_MSG_CODE_2 Character(3) VARCHAR2(3) NOT NULL Message Code 2
    28 PG_MSG_CODE_3 Character(3) VARCHAR2(3) NOT NULL Message Code 3
    29 PG_MSG_CODE_4 Character(3) VARCHAR2(3) NOT NULL Message Code 4
    30 PG_MSG_CODE_5 Character(3) VARCHAR2(3) NOT NULL Message Code 5
    31 PG_MSG_CODE_6 Character(3) VARCHAR2(3) NOT NULL Message Code 6
    32 PG_MSG_CODE_7 Character(3) VARCHAR2(3) NOT NULL Message Code 7
    33 PG_MSG_CODE_8 Character(3) VARCHAR2(3) NOT NULL Message Code 8
    34 PG_MSG_CODE_9 Character(3) VARCHAR2(3) NOT NULL Message Code 9
    35 PG_MSG_CODE_10 Character(3) VARCHAR2(3) NOT NULL Message Code 10
    36 PG_MSG_CODE_11 Character(3) VARCHAR2(3) NOT NULL Message Code 11
    37 PG_MSG_CODE_12 Character(3) VARCHAR2(3) NOT NULL Message Code 12
    38 PG_MSG_CODE_13 Character(3) VARCHAR2(3) NOT NULL Message Code 13
    39 PG_MSG_CODE_14 Character(3) VARCHAR2(3) NOT NULL Message Code 14
    40 PG_MSG_CODE_15 Character(3) VARCHAR2(3) NOT NULL Message Code 15
    41 PG_MSG_CODE_16 Character(3) VARCHAR2(3) NOT NULL Message Code 16
    42 PG_MSG_CODE_17 Character(3) VARCHAR2(3) NOT NULL Message Code 17
    43 PG_MSG_CODE_18 Character(3) VARCHAR2(3) NOT NULL Message Code 18
    44 PG_MSG_CODE_19 Character(3) VARCHAR2(3) NOT NULL Message Code 19
    45 PG_MSG_CODE_20 Character(3) VARCHAR2(3) NOT NULL Message Code 20
    46 PG_MSG_CODE_21 Character(3) VARCHAR2(3) NOT NULL Message Code 21
    47 PG_MSG_CODE_22 Character(3) VARCHAR2(3) NOT NULL Message Code 22
    48 PG_MSG_CODE_23 Character(3) VARCHAR2(3) NOT NULL Message Code 23
    49 PG_MSG_CODE_24 Character(3) VARCHAR2(3) NOT NULL Message Code 24
    50 PG_MSG_CODE_25 Character(3) VARCHAR2(3) NOT NULL Message Code 25
    51 PG_ED_USE_FLAG_1 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 1
    1=Shared SAR ID
    52 PG_ED_USE_FLAG_2 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 2
    1=Verification W Status
    53 PG_ED_USE_FLAG_3 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 3
    1=Concurrent Enrollment
    54 PG_ED_USE_FLAG_4 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 4
    1=POP
    55 PG_ED_USE_FLAG_5 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 5
    56 PG_ED_USE_FLAG_6 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 6
    57 PG_ED_USE_FLAG_7 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 7
    58 PG_ED_USE_FLAG_8 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 8
    59 PG_ED_USE_FLAG_9 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 9
    60 PG_ED_USE_FLAG_10 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 10
    61 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    62 PG_STG_PROC_STAT Character(1) VARCHAR2(1) NOT NULL Pell Staging Rec Proc Status
    E=Error
    N=Not Processed
    P=Processed
    63 PELL_TRANS_DTTM DateTime(26) TIMESTAMP Pell Trans Date/Time
    64 PG_PREV_REG_DISB Character(7) VARCHAR2(7) NOT NULL Prev Regular Disb Amt