ISIR_EX_SIGN_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)
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
4	SIGN_SEQ_NO	Number(5,0)	INTEGER NOT NULL	Signature Page Sequence Number
5	ORIG_SSN	Character(9)	VARCHAR2(9) NOT NULL	Original SSN
6	NAME_CD	Character(2)	VARCHAR2(2) NOT NULL	Name Code
7	IWD_CORR_SIGNED_BY	Character(1)	VARCHAR2(1) NOT NULL	Correction Signed By
8	IWD_EDE_FED_CD	Character(6)	VARCHAR2(6) NOT NULL	EDE Federal School Code
9	TRANS_RECEIPT_DT	Date(10)	DATE	Transaction Receipt Date
10	IWD_SERIAL_NBR	Character(5)	VARCHAR2(5) NOT NULL	Serial Number
11	IWD_RECORD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Record Type 7=PIN Request A=Initial Applications C=Corrections/Duplicates F=FDR Request H=Corrections/Duplicate Req R=Renewal Applications S=Signature Corrections