LN_RPT_PKG_IDLN_OUT_TYPED=Delimited Fields
E=External Product
F=Fixed Length
P=Positional Print
AID_YEAREMPLIDLN_RPT_ORIG_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.LN_RPT_PKG_ID , A.LN_OUT_TYPE , A.AID_YEAR , O.EMPLID , P.NAME , P.LAST_NAME_SRCH , P.FIRST_NAME_SRCH FROM PS_LN_RPT_PKG A , PS_LOAN_ORIGNATN O , PS_SCC_PRI_NAME_VW P WHERE O.PNOTE_PRINT_SEQ = 0 AND O.EMPLID = P.EMPLID AND A.LN_RPT_PKG_ID = ( SELECT DISTINCT(L.LN_RPT_PKG_ID) FROM PS_LN_RPT_LNK L WHERE A.AID_YEAR = L.AID_YEAR AND L.LN_RPT_FORM_ID = O.LN_RPT_FORM_ID AND L.LN_RPT_PKG_ID = A.LN_RPT_PKG_ID) AND A.AID_YEAR = O.AID_YEAR AND P.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PS_SCC_PRI_NAME_VW X1 WHERE X1.EMPLID = P.EMPLID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LN_RPT_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report Package |
| 2 | LN_OUT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
This is the spec for the output type generated for this report. It can be a file with a delimiter between column values, a fixed format file, a file for input to Jetform, or print to a pre-printed form with exact location formatting.
D=Delimited Fields E=External Product F=Fixed Length P=Positional Print |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |