DL_HDR_CHGA3_VW

(SQL View)
 Index Back

DL Header In Stgn Tbl

Direct Loan Header Inbound Stgn Tbl - 2002 Aid Year

SELECT A.DL_BATCH_ID_00 ,C.LN_APPL_ID ,C.EMPLID ,C.INSTITUTION ,C.AID_YEAR ,C.ACAD_CAREER ,C.LOAN_TYPE ,C.LN_APPL_SEQ ,C.ITEM_TYPE ,A.ECTRANSID ,A.ECQUEUEINSTANCE ,A.ECTRANSINOUTSW ,A.LN_HEADER_NBR ,A.DL_HEADER_ID ,A.DL_REC_LNGTH_O ,A.DL_MSG_CLASS ,A.DL_BATCH_ID_00 ,A.DL_HDR_CREATE_DT_O ,A.DL_CREATE_TIME ,A.DL_BATCH_RJCT ,A.DL_HDR_END_DATE_O ,A.LOAN_TRANS_DTTM ,A.PROCESS_INSTANCE ,A.OPRID FROM PS_DL_HDR_03_EC A , PS_DL_CHGACK_03_EC B , PS_LOAN_ORIG_DTL C WHERE A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND A.LN_HEADER_NBR = B.LN_HEADER_NBR AND B.DL_LOAN_ID = C.LN_APPL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRNSFR_BATCH Character(23) VARCHAR2(23) NOT NULL Transfer Batch
2 LN_APPL_ID Character(21) VARCHAR2(21) NOT NULL Loan Application ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
5 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
6 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
7 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
8 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
9 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
10 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)
11 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.
12 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
13 LN_HEADER_NBR Number(3,0) SMALLINT NOT NULL Loan Header Nbr
14 DL_HEADER_ID Character(10) VARCHAR2(10) NOT NULL DL Header ID

Default Value: DL HEADER

15 DL_REC_LNGTH_O Number(4,0) SMALLINT NOT NULL Record Length
16 DL_MSG_CLASS Character(8) VARCHAR2(8) NOT NULL DL Message Class
17 DL_BATCH_ID_00 Character(23) VARCHAR2(23) NOT NULL DL Batch ID
18 DL_HDR_CREATE_DT_O Date(10) DATE DL Create Date
19 DL_CREATE_TIME Character(6) VARCHAR2(6) NOT NULL DL Create Time
20 DL_BATCH_RJCT Character(2) VARCHAR2(2) NOT NULL Direct Loan Batch Reject Code
21 DL_HDR_END_DATE_O Date(10) DATE Direct Lending Header End Date
22 LOAN_TRANS_DTTM DateTime(26) TIMESTAMP Loan Trans Date/Time
23 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
24 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).