DL_CRDT_ACK_EC (SQL Table)	Index Back
DL Credit Decsn Stgn Tbl Direct Loan Credit Acknowledgment Inbound Stgn Tbl - 1997 Aid Year

DL_CRDT_ACK_EC

(SQL Table)

DL Credit Decsn Stgn Tbl

Direct Loan Credit Acknowledgment Inbound Stgn Tbl - 1997 Aid Year

# 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
Default Value: I

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

5 DL_LOAN_ID Character(21) VARCHAR2(21) NOT NULL DL Loan ID

6 DL_SSN Character(9) VARCHAR2(9) NOT NULL DL SSN

7 DL_LOAN_TYPE Character(1) VARCHAR2(1) NOT NULL DL Loan Type Ind
Default Value: P

8 DL_LOAN_SUFFIX Character(9) VARCHAR2(9) NOT NULL DL Loan Suffix

9 DL_CREDIT_DT_O Date(10) DATE DL Credit Decision Date

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

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

12 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
Y/N Table Edit
Default Value: N

#	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 Default Value: I
4	LN_HEADER_NBR	Number(3,0)	SMALLINT NOT NULL	Loan Header Nbr
5	DL_LOAN_ID	Character(21)	VARCHAR2(21) NOT NULL	DL Loan ID
6	DL_SSN	Character(9)	VARCHAR2(9) NOT NULL	DL SSN
7	DL_LOAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	DL Loan Type Ind Default Value: P
8	DL_LOAN_SUFFIX	Character(9)	VARCHAR2(9) NOT NULL	DL Loan Suffix
9	DL_CREDIT_DT_O	Date(10)	DATE	DL Credit Decision Date
10	DL_CREDIT_OVRID	Character(1)	VARCHAR2(1) NOT NULL	Credit Override
11	DL_RECORD_SEQ	Number(5,0)	INTEGER NOT NULL	DL Record Sequence Nbr
12	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 Y/N Table Edit Default Value: N