DL_PNTACK_03_VW

(SQL View)
 Index Back

DL P Note Ack Stgn Tbl '03

Direct Lending Promissory Note Acknowledgement Staging Table for aid year 2002-2003

SELECT ECTRANSID , ECQUEUEINSTANCE , ECTRANSINOUTSW , LN_HEADER_NBR , DL_LOAN_ID , DL_PNOTE_ACPT_DT , DL_BATCH_ID_00 , DL_PPR_PNOTE_STAT , DL_RJCT_1 , DL_RJCT_2 , DL_RJCT_3 , DL_RJCT_4 , DL_RJCT_5 , DL_ANTIC1_GROSS , DL_ANTIC2_GROSS , DL_ANTIC3_GROSS , DL_ANTIC4_GROSS , DL_ANTIC5_GROSS , DL_ANTIC6_GROSS , DL_ANTIC7_GROSS , DL_ANTIC8_GROSS , DL_ANTIC9_GROSS , DL_ANTIC10_GROSS , DL_ANTIC11_GROSS , DL_ANTIC12_GROSS , DL_ANTIC13_GROSS , DL_ANTIC14_GROSS , DL_ANTIC15_GROSS , DL_ANTIC16_GROSS , DL_ANTIC17_GROSS , DL_ANTIC18_GROSS , DL_ANTIC19_GROSS , DL_ANTIC20_GROSS , DL_MST_PROM_ID , DL_MST_PROM_RQST , DL_EMST_PROM_IND , LN_STG_PROC_STAT , PROCESS_INSTANCE FROM PS_DL_PNTACK_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_PNOTE_ACPT_DT Character(8) VARCHAR2(8) NOT NULL DL PNote Accept Dt
7 TRNSFR_BATCH Character(23) VARCHAR2(23) NOT NULL Transfer Batch
8 DL_PPR_PNOTE_STAT Character(1) VARCHAR2(1) NOT NULL DL Paper PNote 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_ANTIC1_GROSS Character(5) VARCHAR2(5) NOT NULL 1st Anticipated Disb Gross
15 DL_ANTIC2_GROSS Character(5) VARCHAR2(5) NOT NULL 2nd Anticipated Disb Gross
16 DL_ANTIC3_GROSS Character(5) VARCHAR2(5) NOT NULL 3rd Anticipated Disb Gross
17 DL_ANTIC4_GROSS Character(5) VARCHAR2(5) NOT NULL 4th Anticipated Disb Gross
18 DL_ANTIC5_GROSS Character(5) VARCHAR2(5) NOT NULL 5th Anticipated Disb Gross
19 DL_ANTIC6_GROSS Character(5) VARCHAR2(5) NOT NULL 6th Anticipated Disb Gross
20 DL_ANTIC7_GROSS Character(5) VARCHAR2(5) NOT NULL 7th Anticipated Disb Gross
21 DL_ANTIC8_GROSS Character(5) VARCHAR2(5) NOT NULL 8th Anticipated Disb Gross
22 DL_ANTIC9_GROSS Character(5) VARCHAR2(5) NOT NULL 9th Anticipated Disb Gross
23 DL_ANTIC10_GROSS Character(5) VARCHAR2(5) NOT NULL 10th Anticipated Disb Gross
24 DL_ANTIC11_GROSS Character(5) VARCHAR2(5) NOT NULL 11th Anticipated Disb Gross
25 DL_ANTIC12_GROSS Character(5) VARCHAR2(5) NOT NULL 12th Anticipated Disb Gross
26 DL_ANTIC13_GROSS Character(5) VARCHAR2(5) NOT NULL 13th Anticipated Disb Gross
27 DL_ANTIC14_GROSS Character(5) VARCHAR2(5) NOT NULL 14th Anticipated Disb Gross
28 DL_ANTIC15_GROSS Character(5) VARCHAR2(5) NOT NULL 15th Anticipated Disb Gross
29 DL_ANTIC16_GROSS Character(5) VARCHAR2(5) NOT NULL 16th Anticipated Disb Gross
30 DL_ANTIC17_GROSS Character(5) VARCHAR2(5) NOT NULL 17th Anticipated Disb Gross
31 DL_ANTIC18_GROSS Character(5) VARCHAR2(5) NOT NULL 18th Anticipated Disb Gross
32 DL_ANTIC19_GROSS Character(5) VARCHAR2(5) NOT NULL 19th Anticipated Disb Gross
33 DL_ANTIC20_GROSS Character(5) VARCHAR2(5) NOT NULL 20th Anticipated Disb Gross
34 DL_MST_PROM_ID Character(21) VARCHAR2(21) NOT NULL Master Prom Note ID
35 DL_MST_PROM_RQST Character(5) VARCHAR2(5) NOT NULL Master Prom Note Request Amt
36 DL_EMST_PROM_IND Character(1) VARCHAR2(1) NOT NULL DL Electronic MPN Indicator
37 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
38 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance