HRS_APP_PER_STATUSA=External Applicant
E=Employee
N=Non-Employee
HRS_PER_STTS_VW(SQL View) |
Index Back |
|---|---|
App Per Status ViewReturns a list of valid person status values. Used by the text catalog configuration. |
| SELECT %Substring(A.FIELDVALUE,1,1) FROM PSXLATITEM A WHERE A.FIELDNAME = 'APP_PER_STATUS' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDVALUE = B.FIELDVALUE AND B.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_APP_PER_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Identifies the type of applicant - External Applicant, Employee or Non-Employee
A=External Applicant E=Employee N=Non-Employee |