SSR_HM_STU_LTX(SQL View) |
Index Back |
|---|---|
Student TransactionLast successful student transaction posted to HEIMS |
| SELECT DISTINCT STU.EMPLID , MAX( STU.SSR_TRANS_ID ) FROM %Table(SSR_HM_STUDENT) STU , %Table(SSR_HM_UID_MAP) MAP WHERE STU.EMPLID = MAP.EMPLID AND MAP.DELETE_FLAG = 'N' AND MAP.EFF_STATUS = 'A' AND MAP.RECNAME = 'SSR_HM_STUDENT' AND STU.IB_RESTMETHOD NOT LIKE 'DELETE' AND STU.SSR_MAP_ID <> 0 GROUP BY STU.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SSR_TRANS_ID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Transaction ID |