INSTITUTIONACAD_PROGACAD_PLANLOCATIONSSR_HM_COC_LTQ(SQL View) |
Index Back |
|---|---|
Last Course Campus TransactionLast Successful transaction of a HEIMS Course on Campus |
| SELECT COC.INSTITUTION , COC.ACAD_PROG , COC.ACAD_PLAN , COC.LOCATION , COC.CRSE_CMP_EFFDT , COC.SSR_TRANS_ID , COC.SSR_SEQ_NBR , COC.SSR_CMPUS_UID , COC.SSR_CRSE_UID FROM PS_SSR_HM_CRSE_CMP COC , PS_SSR_HM_COC_LTX LST_TXN WHERE COC.INSTITUTION= LST_TXN.INSTITUTION AND COC.ACAD_PROG = LST_TXN.ACAD_PROG AND COC.ACAD_PLAN = LST_TXN.ACAD_PLAN AND COC.LOCATION = LST_TXN.LOCATION AND COC.SSR_TRANS_ID = LST_TXN.SSR_TRANS_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | ACAD_PROG |
Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
| 3 | ACAD_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Academic Plan |
| 4 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 5 | CRSE_CMP_EFFDT | Date(10) | DATE | Effective Date |
| 6 | SSR_TRANS_ID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Transaction ID |
| 7 | SSR_SEQ_NBR | Number(4,0) | SMALLINT NOT NULL | Sequence Number |
| 8 | SSR_CMPUS_UID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Campus UID |
| 9 | SSR_CRSE_UID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Course UID |