DL_CHG_03_VW

(SQL View)
 Index Back

DL Orig Chg Stgn Tbl '03

Direct Loan Origination Change Outbound Stgn Tbl - 2002-2003 Aid Year

SELECT ECTRANSID , ECQUEUEINSTANCE , ECTRANSINOUTSW , DL_LOAN_ID , LN_CHG_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 FROM PS_DL_CHG_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)
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: O

4 LN_APPL_ID Character(21) VARCHAR2(21) NOT NULL Loan Application ID
5 LN_CHG_SEQ Number(2,0) SMALLINT NOT NULL Loan Change Sequence
6 DL_LOAN_ID_ERR_CD Character(2) VARCHAR2(2) NOT NULL DL Loan ID Error Cd
7 DL_CHG_FLD_01 Character(4) VARCHAR2(4) NOT NULL DL Change Field 1
8 DL_CHG_VALUE_01_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 1
9 DL_RJCT_1 Character(4) VARCHAR2(4) NOT NULL Reject Code 1
10 DL_CHG_FLD_02 Character(4) VARCHAR2(4) NOT NULL DL Change Field 2
11 DL_CHG_VALUE_02_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 2
12 DL_RJCT_2 Character(4) VARCHAR2(4) NOT NULL Reject Code 2
13 DL_CHG_FLD_03 Character(4) VARCHAR2(4) NOT NULL DL Change Field 3
14 DL_CHG_VALUE_03_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 3
15 DL_RJCT_3 Character(4) VARCHAR2(4) NOT NULL Reject Code 3
16 DL_CHG_FLD_04 Character(4) VARCHAR2(4) NOT NULL DL Change Field 4
17 DL_CHG_VALUE_04_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 4
18 DL_RJCT_4 Character(4) VARCHAR2(4) NOT NULL Reject Code 4
19 DL_CHG_FLD_05 Character(4) VARCHAR2(4) NOT NULL DL Change Field 5
20 DL_CHG_VALUE_05_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 5
21 DL_RJCT_5 Character(4) VARCHAR2(4) NOT NULL Reject Code 5
22 DL_CHG_FLD_06 Character(4) VARCHAR2(4) NOT NULL DL Change Field 6
23 DL_CHG_VALUE_06_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 6
24 DL_RJCT_6 Character(4) VARCHAR2(4) NOT NULL Reject Code 6
25 DL_CHG_FLD_07 Character(4) VARCHAR2(4) NOT NULL DL Change Field 7
26 DL_CHG_VALUE_07_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 7
27 DL_RJCT_7 Character(4) VARCHAR2(4) NOT NULL Reject Code 7
28 DL_CHG_FLD_08 Character(4) VARCHAR2(4) NOT NULL DL Change Field 8
29 DL_CHG_VALUE_08_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 8
30 DL_RJCT_8 Character(4) VARCHAR2(4) NOT NULL Reject Code 8
31 DL_CHG_FLD_09 Character(4) VARCHAR2(4) NOT NULL DL Change Field 9
32 DL_CHG_VALUE_09_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 9
33 DL_RJCT_9 Character(4) VARCHAR2(4) NOT NULL Reject Code 9
34 DL_CHG_FLD_10 Character(4) VARCHAR2(4) NOT NULL DL Change Field 10
35 DL_CHG_VALUE_10_02 Character(50) VARCHAR2(50) NOT NULL DL Change Value 10
36 DL_RJCT_10 Character(4) VARCHAR2(4) NOT NULL Reject Code 10
37 DL_BATCH_ID_00 Character(23) VARCHAR2(23) NOT NULL DL Batch ID