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 Default Value: 0
6	NSLDS_HDR_TITLE	Character(46)	VARCHAR2(46) NOT NULL	NSLDS Header Title
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	Institution OE Branch
9	NSLDS_SVCR_CD	Character(8)	VARCHAR2(8) NOT NULL	NSLDS Servicer
10	NSLDS_RPT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	NSLDS Report Type
11	NSLDS_SUBMITTL_DT	Date(10)	DATE	NSLDS Submittal Date
12	NSLDS_PROCESS_DT	Date(10)	DATE	NSLDS Process Date
13	LOAN_TRANS_DTTM	DateTime(26)	TIMESTAMP	Loan Trans Date/Time
14	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
15	NSLDS_ALERT_DT	Date(10)	DATE	NSLDS Alert File create date.
16	NSLDS_ALERT_SEQ	Number(2,0)	SMALLINT NOT NULL	NSLDS alert file sequence number is incremented if more than one alert file is created on the same day.