INSTITUTIONCALENDAR_YEAREMPLIDEFFDTT2202_FLAT_VW(SQL View) |
Index Back |
|---|---|
T2202 Data - FlattenedView used to flatten the T2202 Data records into one row which contains all rows from T2202_DATA separated into distinct fields, and includes totals for Fees, Nbr of FT/PT months. Used in T2202 Batch Print process as part of the query SSF_2202_PRT. |
| SELECT A.INSTITUTION , A.CALENDAR_YEAR , A.EMPLID , A.EFFDT , B.YEAR_FROM , B.MONTH_FROM , B.YEAR_TO , B.MONTH_TO , B.NBR_PART_MTHS , B.NBR_FULL_MTHS , B.FEE_AMT , C.YEAR_FROM , C.MONTH_FROM , C.YEAR_TO , C.MONTH_TO , C.NBR_PART_MTHS , C.NBR_FULL_MTHS , C.FEE_AMT , D.YEAR_FROM , D.MONTH_FROM , D.YEAR_TO , D.MONTH_TO , D.NBR_PART_MTHS , D.NBR_FULL_MTHS , D.FEE_AMT , E.YEAR_FROM , E.MONTH_FROM , E.YEAR_TO , E.MONTH_TO , E.NBR_PART_MTHS , E.NBR_FULL_MTHS , E.FEE_AMT , F.NBR_PART_MTHS , F.NBR_FULL_MTHS , F.FEE_AMT FROM PS_T2202_HDR_VW A LEFT OUTER JOIN PS_T2202_DATA_1_VW B ON A.INSTITUTION = B.INSTITUTION AND A.CALENDAR_YEAR = B.CALENDAR_YEAR AND A.EMPLID = B.EMPLID AND A.EFFDT = B.EFFDT LEFT OUTER JOIN PS_T2202_DATA_2_VW C ON A.INSTITUTION = C.INSTITUTION AND A.CALENDAR_YEAR = C.CALENDAR_YEAR AND A.EMPLID = C.EMPLID AND A.EFFDT = C.EFFDT LEFT OUTER JOIN PS_T2202_DATA_3_VW D ON A.INSTITUTION = D.INSTITUTION AND A.CALENDAR_YEAR = D.CALENDAR_YEAR AND A.EMPLID = D.EMPLID AND A.EFFDT = D.EFFDT LEFT OUTER JOIN PS_T2202_DATA_4_VW E ON A.INSTITUTION = E.INSTITUTION AND A.CALENDAR_YEAR = E.CALENDAR_YEAR AND A.EMPLID = E.EMPLID AND A.EFFDT = E.EFFDT , PS_T2202_SUM_VW F WHERE A.INSTITUTION = F.INSTITUTION AND A.CALENDAR_YEAR = F.CALENDAR_YEAR AND A.EMPLID = F.EMPLID AND A.EFFDT = F.EFFDT AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | YEAR_FROM1 | Number(4,0) | SMALLINT NOT NULL | Year From |
| 6 | MONTH_FROM1 | Number(2,0) | SMALLINT NOT NULL | Month From - Seq 1 |
| 7 | YEAR_TO1 | Number(4,0) | SMALLINT NOT NULL | Year To - Seq 1 |
| 8 | MONTH_TO1 | Number(2,0) | SMALLINT NOT NULL | Month To - Seq 1 |
| 9 | NBR_PART_MTHS1 | Number(3,0) | SMALLINT NOT NULL | Number of Part Time Months - Seq 1 |
| 10 | NBR_FULL_MTHS1 | Number(3,0) | SMALLINT NOT NULL | Number of Full Months - Seq 1 |
| 11 | FEE_AMT1 | Number(15,2) | DECIMAL(14,2) NOT NULL | Fee Amount - Seq 1 |
| 12 | YEAR_FROM2 | Number(4,0) | SMALLINT NOT NULL | Year From - Seq 2 |
| 13 | MONTH_FROM2 | Number(2,0) | SMALLINT NOT NULL | Month From - Seq 2 |
| 14 | YEAR_TO2 | Number(4,0) | SMALLINT NOT NULL | Year To - Seq 2 |
| 15 | MONTH_TO2 | Number(2,0) | SMALLINT NOT NULL | Month To - Seq 2 |
| 16 | NBR_PART_MTHS2 | Number(3,0) | SMALLINT NOT NULL | Number of Part Time Months - Seq 2 |
| 17 | NBR_FULL_MTHS2 | Number(3,0) | SMALLINT NOT NULL | Number of Full Months - Seq 2 |
| 18 | FEE_AMT2 | Number(15,2) | DECIMAL(14,2) NOT NULL | Fee Amount - Seq 2 |
| 19 | YEAR_FROM3 | Number(4,0) | SMALLINT NOT NULL | Year From - Seq 3 |
| 20 | MONTH_FROM3 | Number(2,0) | SMALLINT NOT NULL | Month From - Seq 3 |
| 21 | YEAR_TO3 | Number(4,0) | SMALLINT NOT NULL | Year To - Seq 3 |
| 22 | MONTH_TO3 | Number(2,0) | SMALLINT NOT NULL | Month To - Seq 3 |
| 23 | NBR_PART_MTHS3 | Number(3,0) | SMALLINT NOT NULL | Number of Part Time Months - Seq 3 |
| 24 | NBR_FULL_MTHS3 | Number(3,0) | SMALLINT NOT NULL | Number of Full Months - Seq 3 |
| 25 | FEE_AMT3 | Number(15,2) | DECIMAL(14,2) NOT NULL | Fee Amount - Seq 3 |
| 26 | YEAR_FROM4 | Number(4,0) | SMALLINT NOT NULL | Year From - Seq 4 |
| 27 | MONTH_FROM4 | Number(2,0) | SMALLINT NOT NULL | Month From - Seq 4 |
| 28 | YEAR_TO4 | Number(4,0) | SMALLINT NOT NULL | Year To - Seq 4 |
| 29 | MONTH_TO4 | Number(2,0) | SMALLINT NOT NULL | Month To - Seq 4 |
| 30 | NBR_PART_MTHS4 | Number(3,0) | SMALLINT NOT NULL | Number of Part Time Months - Seq 4 |
| 31 | NBR_FULL_MTHS4 | Number(3,0) | SMALLINT NOT NULL | Number of Full Months - Seq 4 |
| 32 | FEE_AMT4 | Number(15,2) | DECIMAL(14,2) NOT NULL | Fee Amount - Seq 4 |
| 33 | NBR_PART_MTHS | Number(3,0) | SMALLINT NOT NULL | Number of Parttime Months |
| 34 | NBR_FULL_MTHS | Number(3,0) | SMALLINT NOT NULL | Number of Fulltime Months |
| 35 | FEE_AMT | Number(15,2) | DECIMAL(14,2) NOT NULL | Fee Amount |