SSR_HM_SCWS_LTX(SQL View) |
Index Back |
|---|---|
Student CWSLast successful student commomwealth scholarships transaction to HEIMS |
| SELECT DISTINCT STU.EMPLID , STU.SSR_CWLTHSCH_TYPE , STU.SSR_REPORTING_YR , STU.SSR_REPORTING_PER , STU.SSR_CWLTHSCH_STAT , MAX( STU.SSR_TRANS_ID ) FROM %Table(SSR_HM_CWLTHSCH) STU , %Table(SSR_HM_UID_MAP) MAP WHERE STU.EMPLID = MAP.EMPLID AND STU.SSR_MAP_ID = MAP.SSR_MAP_ID AND MAP.DELETE_FLAG = 'N' AND MAP.EFF_STATUS = 'A' AND MAP.RECNAME = 'SSR_HM_CWLTHSCH' AND STU.IB_RESTMETHOD NOT LIKE 'DELETE' AND STU.SSR_MAP_ID <> 0 GROUP BY STU.EMPLID, STU.SSR_CWLTHSCH_TYPE , STU.SSR_REPORTING_YR , STU.SSR_REPORTING_PER, STU.SSR_CWLTHSCH_STAT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SSR_CWLTHSCH_TYPE | Character(1) | VARCHAR2(1) NOT NULL | HEIMS Commonwealth Scholarship Type |
| 3 | SSR_REPORTING_YR | Character(4) | VARCHAR2(4) NOT NULL | HEIMS Reporting Year |
| 4 | SSR_REPORTING_PER | Character(1) | VARCHAR2(1) NOT NULL | HEIMS Reporting Period |
| 5 | SSR_CWLTHSCH_STAT | Character(1) | VARCHAR2(1) NOT NULL | HEIMS Commonwealth Scholarship Status Code |
| 6 | SSR_TRANS_ID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Transaction ID |