LN_DL_PNOTE_ACT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	DL_PNOTE_ID	Character(21)	VARCHAR2(21) NOT NULL	DL Pnote Unique ID
3	PNOTE_ACTN_SEQ	Number(3,0)	SMALLINT NOT NULL	Promissory Note Action Seq
4	LN_PNOTE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Loan Pnote Status A=Accepted C=Closed E=Endorser I=Inactive R=Rejected X=Pending
5	PNOTE_AMT	Number(5,0)	INTEGER NOT NULL	Promissory Note Amount
6	LN_PNOTE_SIGNED	Character(1)	VARCHAR2(1) NOT NULL	Borrower Signature Y/N Table Edit
7	PNOTE_SGNTR_DT	Date(10)	DATE	Promissory Note Signature Dt
8	LN_STU_SIGNTR	Character(1)	VARCHAR2(1) NOT NULL	Student Signature Y/N Table Edit
9	LN_STU_SIG_DT	Date(10)	DATE	Student Signature Date
10	LN_ACTION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Loan Action Type
11	LN_ACTION_CD	Character(4)	VARCHAR2(4) NOT NULL	Loan Action Cd
12	LN_ACTION_DT	DateTime(26)	TIMESTAMP	Loan Action Dttm
13	LN_ACTION_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Loan Action Status A=Accptd-Not Applied B=Accepted F=Failed Rule I=Invalid L=Lower Endorser Amount accepted O=Authorized for Transfer P=Pending R=Rejected T=Transmitted U=Received W=Accepted with Corrected Award
14	LN_ACTNSTAT_DT	Date(10)	DATE	Loan Action Status Dt
15	TRNSFR_BATCH	Character(23)	VARCHAR2(23) NOT NULL	Transfer Batch
16	LN_BOOK_STAT	Character(1)	VARCHAR2(1) NOT NULL	Direct Lending Booked Status A=Booked R=Unbooked
17	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
18	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
19	SFA_CR_DOCUMENT_ID	Character(34)	VARCHAR2(34) NOT NULL	Document ID