NSLDS_OVRPYM_EC

(SQL Table)
 Index Back

NSLDS Overpayment Stg Tbl

NSLDS FAT Overpayment Data Staging Table

  • Parent record: NSLDS_HDR_IN_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)

    Default Value: SHFATEOP

    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

    Default Value: I

    4 NSLDS_HEADER_NBR Number(3,0) SMALLINT NOT NULL NSLDS Header Nbr
    5 NSLDS_REC_TYPE Character(1) VARCHAR2(1) NOT NULL NSLDS Record Type Ind
    6 NSLDS_DTL_NBR Number(6,0) INTEGER NOT NULL NSLDS Detail Nbr
    7 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    8 NSLDS_OVRPYM_TYPE Character(2) VARCHAR2(2) NOT NULL NSLDS Overpayment Type
    AG=ACG
    IA=IASA
    PE=Pell
    PK=Perkins
    SE=FSEOG
    SG=NSG
    TG=TEACH
    9 NSLDS_OVRPYM_INDC Character(1) VARCHAR2(1) NOT NULL NSLDS Overpayment Indc
    F=Fraud
    F=Fraud
    N=No
    S=Satisfactory Arrangement
    Y=Yes
    10 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    11 NSLDS_CONTACT Character(8) VARCHAR2(8) NOT NULL NSLDS Contact