HCSC_PERS_EVT_V(SQL View) |
Index Back |
|---|---|
Employee Personal EventsEmployee Personal Events Birthday, Work Anniversary |
| SELECT A.EMPLID , A.BIRTHDATE , MIN(B.ORIG_HIRE_DT) FROM PS_PERSON A , PS_PER_ORG_INST B , PS_PER_ORG_ASGN C WHERE A.EMPLID =B.EMPLID AND B.EMPLID = C.EMPLID AND B.ORG_INSTANCE_ERN = C.ORG_INSTANCE_ERN GROUP BY A.EMPLID, A.BIRTHDATE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 3 | ORIG_HIRE_DT | Date(10) | DATE | Original Start Date |