NSLDS_PELL_EC

(SQL Table)
 Index Back

NSLDS Pell Staging Table

NSLDS FAT Pell 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_PELL_AMT2PAY Number(6,0) INTEGER NOT NULL NSLDS Pell Amt to Pay
    9 NSLDS_PELL_PD2DT Number(6,0) INTEGER NOT NULL NSLDS Pell Paid to Date
    10 NSLDS_PELL_SCHDAMT Number(6,0) INTEGER NOT NULL NSLDS Pell Sched Amt
    11 NSLDS_PELL_PRCNT Number(8,4) DECIMAL(7,4) NOT NULL NSLDS Pell Prcnt Used
    12 NSLDS_PELL_SCHL_CD Character(8) VARCHAR2(8) NOT NULL NSLDS Pell School Cd
    13 NSLDS_PELL_TXN_NBR Character(2) VARCHAR2(2) NOT NULL NSLDS Pell Txn Nbr
    14 NSLDS_PELL_UPDT Date(10) DATE NSLDS Pell Last Updt
    15 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    16 NSLDS_PELL_VER_FLG Character(3) VARCHAR2(3) NOT NULL NSLDS Pell Verif Flag
    17 NSLDS_PELLEFC Character(6) VARCHAR2(6) NOT NULL NSLDS Pell EFC
    18 NSLDS_PELLSCHAMT Character(6) VARCHAR2(6) NOT NULL NSLDS Pell Sched Amt
    19 NSLDS_PELL_CHNG Character(1) VARCHAR2(1) NOT NULL NSLDS Pell change flag indicates that a changed Pell Grant record is contained in the NSLDS alert file.

    Y/N Table Edit

    20 NSLDS_PELL_UPDT_O Character(8) VARCHAR2(8) NOT NULL NSLDS Pell Last Updt
    21 NSLDS_PELL_POST_DT Character(8) VARCHAR2(8) NOT NULL Date Posted to Pell System
    22 SFA_GRANT_TYPE Character(2) VARCHAR2(2) NOT NULL Grant Type
    23 SFA_ACG_ELIG_CD Character(2) VARCHAR2(2) NOT NULL Eligibility Code
    01=High School Program
    02=AP/IB Courses
    03=Rigorous High School Programs
    24 SFA_ACG_HS_PGM Character(6) VARCHAR2(6) NOT NULL High School Prog
    25 SFA_NSG_SCHL_YR Character(1) VARCHAR2(1) NOT NULL NSG Academic Level
    26 SFA_AWARD_ID Character(21) VARCHAR2(21) NOT NULL Award ID
    27 SFA_NSG_INST_PG Character(7) VARCHAR2(7) NOT NULL Instructional Program Code
    28 SFA_PELL_PYPRD_LMT Character(4) VARCHAR2(4) NOT NULL Pell Payment Period Limit
    29 SFA_NSG_SEQ_CD Character(3) VARCHAR2(3) NOT NULL NSG COD Sequence Code
    30 SFA_NSG_LVL_PCTUSD Number(8,4) DECIMAL(7,4) NOT NULL Total Elig Acad Year Level
    31 SFA_TCH_LN_CNV_FLG Character(1) VARCHAR2(1) NOT NULL TEACH Grant Loan Conv
    1=Yes
    2=No
    32 SFA_TCH_CONV_DT Character(8) VARCHAR2(8) NOT NULL Loan Conversion Date
    33 SFA_NSLDS_ADD_IND Character(1) VARCHAR2(1) NOT NULL Additional Elig Indicator
    34 SFA_DECSD_VET_IND Character(1) VARCHAR2(1) NOT NULL Post 9/11 Dependent
    35 SFA_FIRST_PELL_IND Character(1) VARCHAR2(1) NOT NULL First Time Pell Indicator
    36 SFA_CFH_INDICATOR Character(1) VARCHAR2(1) NOT NULL Children of Fallen Heroes
    1=Yes
    2=No