EMPLIDSSR_CWLTHSCH_TYPESSR_REPORTING_YRSSR_REPORTING_PERSSR_CWLTHSCH_STATSSR_HM_SCWS_LTQ(SQL View) |
Index Back |
|---|---|
Student CWSLast successful student commomwealth scholarships transaction to HEIMS |
| SELECT STU_TXN.EMPLID , STU_TXN.SSR_CWLTHSCH_TYPE , STU_TXN.SSR_REPORTING_YR , STU_TXN.SSR_REPORTING_PER , STU_TXN.SSR_CWLTHSCH_STAT , STU_TXN.SSR_CWLTHSCH_TERM , STU_TXN.SSR_CWLTHSCH_AMT , STU_TXN.SSR_TRANS_ID , STU_TXN.SSR_SEQ_NBR , STU_TXN.SSR_SEQ_NBR2 , STU_TXN.SCC_ROW_ADD_DTTM , STU_TXN.SCC_ROW_UPD_DTTM , STU_TXN.SSR_MAP_ID FROM %Table(SSR_HM_SCWS_LTX) LST_TXN , %Table(SSR_HM_CWLTHSCH) STU_TXN WHERE STU_TXN.EMPLID = LST_TXN.EMPLID AND STU_TXN.SSR_CWLTHSCH_TYPE = LST_TXN.SSR_CWLTHSCH_TYPE AND STU_TXN.SSR_CWLTHSCH_STAT = LST_TXN.SSR_CWLTHSCH_STAT AND STU_TXN.SSR_REPORTING_YR = LST_TXN.SSR_REPORTING_YR AND STU_TXN.SSR_REPORTING_PER = LST_TXN.SSR_REPORTING_PER AND STU_TXN.SSR_TRANS_ID = LST_TXN.SSR_TRANS_ID |
| # | 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_CWLTHSCH_TERM | Character(1) | VARCHAR2(1) NOT NULL | HEIMS Commonwealth Scholarship Termination Reason Code |
| 7 | SSR_CWLTHSCH_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | HEIMS Commonwealth Scholarship Amount |
| 8 | SSR_TRANS_ID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Transaction ID |
| 9 | SSR_SEQ_NBR | Number(4,0) | SMALLINT NOT NULL | Sequence Number |
| 10 | SSR_SEQ_NBR2 | Number(4,0) | SMALLINT NOT NULL | Sequence Number 2 |
| 11 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 12 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |
| 13 | SSR_MAP_ID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Map ID |