DL_CHGACK_03_VW

(SQL View)
Index Back

DL Orig Chg Ack Stgn Tbl '03

Direct Loan Origination Change Acknowledgement Inbound Staging Table - 2002-2003 Aid Year

SELECT ECTRANSID , ECQUEUEINSTANCE , ECTRANSINOUTSW , LN_HEADER_NBR , DL_LOAN_ID , DL_RECORD_SEQ , DL_LOAN_ID_ERR_CD , DL_CHG_FLD_01 , DL_CHG_VALUE_01_02 , DL_RJCT_1 , DL_CHG_FLD_02 , DL_CHG_VALUE_02_02 , DL_RJCT_2 , DL_CHG_FLD_03 , DL_CHG_VALUE_03_02 , DL_RJCT_3 , DL_CHG_FLD_04 , DL_CHG_VALUE_04_02 , DL_RJCT_4 , DL_CHG_FLD_05 , DL_CHG_VALUE_05_02 , DL_RJCT_5 , DL_CHG_FLD_06 , DL_CHG_VALUE_06_02 , DL_RJCT_6 , DL_CHG_FLD_07 , DL_CHG_VALUE_07_02 , DL_RJCT_7 , DL_CHG_FLD_08 , DL_CHG_VALUE_08_02 , DL_RJCT_8 , DL_CHG_FLD_09 , DL_CHG_VALUE_09_02 , DL_RJCT_9 , DL_CHG_FLD_10 , DL_CHG_VALUE_10_02 , DL_RJCT_10 , DL_BATCH_ID_00 , LN_STG_PROC_STAT , PROCESS_INSTANCE FROM PS_DL_CHGACK_03_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: DIOC01OP

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 LN_APPL_ID Character(21) VARCHAR2(21) NOT NULL Loan Application ID
6 DL_RECORD_SEQ Number(5,0) INTEGER NOT NULL DL Record Sequence Nbr
7 DL_LOAN_ID_ERR_CD Character(2) VARCHAR2(2) NOT NULL DL Loan ID Error Cd

Default Value: AC

8 DL_CHG_FLD_01 Character(4) VARCHAR2(4) NOT NULL DL Change Field 1
9 DL_CHG_VALUE_01_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 1
10 DL_RJCT_1 Character(4) VARCHAR2(4) NOT NULL Reject Code 1
11 DL_CHG_FLD_02 Character(4) VARCHAR2(4) NOT NULL DL Change Field 2
12 DL_CHG_VALUE_02_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 2
13 DL_RJCT_2 Character(4) VARCHAR2(4) NOT NULL Reject Code 2
14 DL_CHG_FLD_03 Character(4) VARCHAR2(4) NOT NULL DL Change Field 3
15 DL_CHG_VALUE_03_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 3
16 DL_RJCT_3 Character(4) VARCHAR2(4) NOT NULL Reject Code 3
17 DL_CHG_FLD_04 Character(4) VARCHAR2(4) NOT NULL DL Change Field 4
18 DL_CHG_VALUE_04_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 4
19 DL_RJCT_4 Character(4) VARCHAR2(4) NOT NULL Reject Code 4
20 DL_CHG_FLD_05 Character(4) VARCHAR2(4) NOT NULL DL Change Field 5
21 DL_CHG_VALUE_05_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 5
22 DL_RJCT_5 Character(4) VARCHAR2(4) NOT NULL Reject Code 5
23 DL_CHG_FLD_06 Character(4) VARCHAR2(4) NOT NULL DL Change Field 6
24 DL_CHG_VALUE_06_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 6
25 DL_RJCT_6 Character(4) VARCHAR2(4) NOT NULL Reject Code 6
26 DL_CHG_FLD_07 Character(4) VARCHAR2(4) NOT NULL DL Change Field 7
27 DL_CHG_VALUE_07_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 7
28 DL_RJCT_7 Character(4) VARCHAR2(4) NOT NULL Reject Code 7
29 DL_CHG_FLD_08 Character(4) VARCHAR2(4) NOT NULL DL Change Field 8
30 DL_CHG_VALUE_08_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 8
31 DL_RJCT_8 Character(4) VARCHAR2(4) NOT NULL Reject Code 8
32 DL_CHG_FLD_09 Character(4) VARCHAR2(4) NOT NULL DL Change Field 9
33 DL_CHG_VALUE_09_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 9
34 DL_RJCT_9 Character(4) VARCHAR2(4) NOT NULL Reject Code 9
35 DL_CHG_FLD_10 Character(4) VARCHAR2(4) NOT NULL DL Change Field 10
36 DL_CHG_VALUE_10_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 10
37 DL_RJCT_10 Character(4) VARCHAR2(4) NOT NULL Reject Code 10
38 TRNSFR_BATCH Character(23) VARCHAR2(23) NOT NULL Transfer Batch
39 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
40 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance