NSLDS_CHNG_SRCH

(SQL View)
 Index Back

Unreviewed NSLDS transfer info


SELECT A.ECQUEUEINSTANCE , A.NSLDS_HEADER_NBR , A.NSLDS_DTL_NBR , A.EMPLID ,A.CPS_SCHOOL_CODE ,A.INSTIT_OE_BR , A.SSN , A.NSLDS_PELL_CHNG , A.NSLDS_LOAN_CHNG , A.NSLDS_AGGR_CHNG , A.NSLDS_REVIEW_STAT FROM PS_NSLDS_AGGR_EC A WHERE A.LN_STG_PROC_STAT = 'L' AND A.NSLDS_REVIEW_STAT = 'N' AND A.EMPLID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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.
2 NSLDS_HEADER_NBR Number(3,0) SMALLINT NOT NULL NSLDS Header Nbr
3 NSLDS_DTL_NBR Number(6,0) INTEGER NOT NULL NSLDS Detail Nbr
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
6 INSTIT_OE_BR Character(2) VARCHAR2(2) NOT NULL Branch Code
7 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
8 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.
9 NSLDS_LOAN_CHNG Character(1) VARCHAR2(1) NOT NULL NSLDS Loan change flag indicates that a changed loan record is contained in the NSLDS alert file.
10 NSLDS_AGGR_CHNG Character(1) VARCHAR2(1) NOT NULL NSLDS Aggregate change flag indicates that new aggregate information is contained in the NSLDS alert file.
11 NSLDS_REVIEW_STAT Character(1) VARCHAR2(1) NOT NULL Alert Record Review Status

Y/N Table Edit