NSLDS_SUSP_SRCH (SQL View)	Index Back
Srch rec for NSLDS_SUSP_MGMT

NSLDS_SUSP_SRCH

(SQL View)

Srch rec for NSLDS_SUSP_MGMT

SELECT A.OPRCLASS , A.ECTRANSID , A.ECQUEUEINSTANCE ,A.NSLDS_HEADER_NBR ,A.NSLDS_DTL_NBR ,A.NSLDS_REC_TYPE ,A.CPS_SCHOOL_CODE ,A.INSTIT_OE_BR ,A.EMPLID , A.SSN , A.SSN_MSK , A.NSLDS_FIRST_NAME , A.NSLDS_LAST_NAME , A.NSLDS_DOB , A.NSLDS_DOB_MSK , A.LN_STG_PROC_STAT FROM PS_NSLDS_AGGR_EC_V A , PS_ECQUEUE B WHERE A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND B.ECQUEUESTATUS ='L' AND A.ECTRANSID IN ('TRALRTOP','FAHEXTOP')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

2 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)
Prompt Table: SFA_NSLDS_ET_VW

3 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.

4 NSLDS_HEADER_NBR Number(3,0) SMALLINT NOT NULL NSLDS Header Nbr

5 NSLDS_DTL_NBR Number(6,0) INTEGER NOT NULL NSLDS Detail Nbr

6 NSLDS_REC_TYPE Character(1) VARCHAR2(1) NOT NULL NSLDS Record Type Ind

7 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code

8 INSTIT_OE_BR Character(2) VARCHAR2(2) NOT NULL Branch Code

9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

10 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #

11 SSN_MSK Character(9) VARCHAR2(9) NOT NULL Social Security #

12 NSLDS_FIRST_NAME Character(12) VARCHAR2(12) NOT NULL First Name

13 NSLDS_LAST_NAME Character(35) VARCHAR2(35) NOT NULL Last Name

14 NSLDS_DOB Date(10) DATE NSLDS Date of Birth

15 NSLDS_DOB_MSK Character(10) VARCHAR2(10) NOT NULL NSLDS Date of Birth

16 LN_STG_PROC_STAT Character(1) VARCHAR2(1) NOT NULL Load Status
E=Error
K=Skipped
L=Loaded
N=Not Processed
S=Skip
U=Unprocessed
X=Suspended
Y=Processed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
2	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) Prompt Table: SFA_NSLDS_ET_VW
3	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.
4	NSLDS_HEADER_NBR	Number(3,0)	SMALLINT NOT NULL	NSLDS Header Nbr
5	NSLDS_DTL_NBR	Number(6,0)	INTEGER NOT NULL	NSLDS Detail Nbr
6	NSLDS_REC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	NSLDS Record Type Ind
7	CPS_SCHOOL_CODE	Character(6)	VARCHAR2(6) NOT NULL	CPS School Code. Also known as Title IV School Code
8	INSTIT_OE_BR	Character(2)	VARCHAR2(2) NOT NULL	Branch Code
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
11	SSN_MSK	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
12	NSLDS_FIRST_NAME	Character(12)	VARCHAR2(12) NOT NULL	First Name
13	NSLDS_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	Last Name
14	NSLDS_DOB	Date(10)	DATE	NSLDS Date of Birth
15	NSLDS_DOB_MSK	Character(10)	VARCHAR2(10) NOT NULL	NSLDS Date of Birth
16	LN_STG_PROC_STAT	Character(1)	VARCHAR2(1) NOT NULL	Load Status E=Error K=Skipped L=Loaded N=Not Processed S=Skip U=Unprocessed X=Suspended Y=Processed