DL_ORGACK_03_VW

(SQL View)
 Index Back

DL Full Orig Ackn Stgn Tbl

Direct Loan Origination Acknowledgment Inbound Stgn Tbl - 2003 Aid Year

SELECT ECTRANSID , ECQUEUEINSTANCE , ECTRANSINOUTSW , LN_HEADER_NBR , DL_LOAN_ID , DL_ACKNWLDG_DT , DL_BATCH_ID_00 , DL_ORIG_STATUS , DL_RJCT_1 , DL_RJCT_2 , DL_RJCT_3 , DL_RJCT_4 , DL_RJCT_5 , DL_MST_PROM_STAT , DL_EMST_PROM_IND , DL_MST_PROM_IND , DL_MST_PROM_RQST , LN_STG_PROC_STAT , PROCESS_INSTANCE FROM PS_DL_ORGACK_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: 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_ACKNWLDG_DT Character(8) VARCHAR2(8) NOT NULL DL Acknowledgement Dt
7 TRNSFR_BATCH Character(23) VARCHAR2(23) NOT NULL Transfer Batch
8 DL_ORIG_STATUS Character(1) VARCHAR2(1) NOT NULL DL Full Orig Status
9 DL_RJCT_1 Character(4) VARCHAR2(4) NOT NULL Reject Code 1
10 DL_RJCT_2 Character(4) VARCHAR2(4) NOT NULL Reject Code 2
11 DL_RJCT_3 Character(4) VARCHAR2(4) NOT NULL Reject Code 3
12 DL_RJCT_4 Character(4) VARCHAR2(4) NOT NULL Reject Code 4
13 DL_RJCT_5 Character(4) VARCHAR2(4) NOT NULL Reject Code 5
14 DL_MST_PROM_STAT Character(1) VARCHAR2(1) NOT NULL Master Prom Note Stat
15 DL_EMST_PROM_IND Character(1) VARCHAR2(1) NOT NULL DL Electronic MPN Indicator
16 DL_MST_PROM_IND Character(1) VARCHAR2(1) NOT NULL Master Prom Note Indicator
17 DL_MST_PROM_RQST Character(5) VARCHAR2(5) NOT NULL Master Prom Note Request Amt
18 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
19 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance