EMPLIDDefault Value: NEW
Prompt Table: PERSON
HRS_ACTPOI_I(SQL View) |
Index Back |
|---|---|
Active PeopleInterface View for Active People |
| SELECT P.EMPLID FROM PS_PER_POI_TRANS P WHERE P.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_PER_POI_TRANS C WHERE C.EMPLID = P.EMPLID AND C.EFFDT <= %CurrentDateIn) AND P.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW Prompt Table: PERSON |