DL_CRDACK_02_VW (SQL View)	Index Back
DL Cr Decsn Stgn Tbl '02 Direct Loan Credit Decision Acknowledgment Inbound Stgn Tbl - 2001-2002 Aid Year

DL_CRDACK_02_VW

(SQL View)

DL Cr Decsn Stgn Tbl '02

Direct Loan Credit Decision Acknowledgment Inbound Stgn Tbl - 2001-2002 Aid Year

SELECT B.DL_BATCH_ID_00, A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.LN_HEADER_NBR , A.DL_LOAN_ID , A.DL_CREDIT_DT , A.DL_CREDIT_OVRID , A.DL_RECORD_SEQ , A.LN_STG_PROC_STAT , A.PROCESS_INSTANCE FROM PS_DL_CRDACK_02_EC A, PS_DL_HDR_02_EC B WHERE A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND A.LN_HEADER_NBR = B.LN_HEADER_NBR

Parent record: DL_HDR_02_EC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRNSFR_BATCH Character(23) VARCHAR2(23) NOT NULL Transfer Batch

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)

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

5 LN_HEADER_NBR Number(3,0) SMALLINT NOT NULL Loan Header Nbr

6 LN_APPL_ID Character(21) VARCHAR2(21) NOT NULL Loan Application ID

7 DL_CREDIT_DT Character(8) VARCHAR2(8) NOT NULL Credit Decision Dt

8 DL_CREDIT_OVRID Character(1) VARCHAR2(1) NOT NULL Credit Override

9 DL_RECORD_SEQ Number(5,0) INTEGER NOT NULL DL Record Sequence Nbr

10 LN_STG_PROC_STAT Character(1) VARCHAR2(1) NOT NULL Loan Staging Record Proc Stat
E=Error
K=Skipped
L=Loaded
N=Not Processed
S=Skip
U=Unprocessed
X=Suspended
Y=Processed

11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRNSFR_BATCH	Character(23)	VARCHAR2(23) NOT NULL	Transfer Batch
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)
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	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
5	LN_HEADER_NBR	Number(3,0)	SMALLINT NOT NULL	Loan Header Nbr
6	LN_APPL_ID	Character(21)	VARCHAR2(21) NOT NULL	Loan Application ID
7	DL_CREDIT_DT	Character(8)	VARCHAR2(8) NOT NULL	Credit Decision Dt
8	DL_CREDIT_OVRID	Character(1)	VARCHAR2(1) NOT NULL	Credit Override
9	DL_RECORD_SEQ	Number(5,0)	INTEGER NOT NULL	DL Record Sequence Nbr
10	LN_STG_PROC_STAT	Character(1)	VARCHAR2(1) NOT NULL	Loan Staging Record Proc Stat E=Error K=Skipped L=Loaded N=Not Processed S=Skip U=Unprocessed X=Suspended Y=Processed
11	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance