SSR_HM_SDSB_LTX(SQL View) |
Index Back |
|---|---|
Student DisabilityLast successful student disability transaction posted to HEIMS |
| SELECT DISTINCT STU.EMPLID , STU.SSR_DISABLTY_CODE , MAX( STU.SSR_TRANS_ID ) FROM %Table(SSR_HM_DISABLTY) 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_DISABLTY' AND STU.IB_RESTMETHOD NOT LIKE 'DELETE' AND STU.SSR_MAP_ID <> 0 GROUP BY STU.EMPLID, STU.SSR_DISABLTY_CODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SSR_DISABLTY_CODE | Character(2) | VARCHAR2(2) NOT NULL | HEIMS Disability Code |
| 3 | SSR_TRANS_ID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Transaction ID |