DL_PNTACK_01_VW

(SQL View)
 Index Back

DL P Note Ack Stgn Tbl '01

Direct Lending Promissory Note Acknowledgement Staging Table for aid year 2000-2001

SELECT ECTRANSID , ECQUEUEINSTANCE , ECTRANSINOUTSW , LN_HEADER_NBR , DL_LOAN_ID , DL_PNOTE_ACPT_DT , DL_BATCH_ID_00 , DL_PPR_PNOTE_STAT , DL_PNT_00_RJCT1 , DL_PNT_00_RJCT2 , DL_PNT_00_RJCT3 , DL_PNT_00_RJCT4 , DL_PNT_00_RJCT5 , 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 , LN_STG_PROC_STAT , PROCESS_INSTANCE FROM PS_DL_PNTACK_01_EC

  • Parent record: DL_HDR_01_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_PNT_00_RJCT1 Character(2) VARCHAR2(2) NOT NULL DL Pnote Reject 1
    10 DL_PNT_00_RJCT2 Character(2) VARCHAR2(2) NOT NULL DL Pnote Reject 2
    11 DL_PNT_00_RJCT3 Character(2) VARCHAR2(2) NOT NULL DL Pnote Reject 3
    12 DL_PNT_00_RJCT4 Character(2) VARCHAR2(2) NOT NULL DL Pnote Reject 4
    13 DL_PNT_00_RJCT5 Character(2) VARCHAR2(2) NOT NULL DL Pnote Reject 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 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
    37 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance