HR_SALCHGDAT_VW(SQL View) |
Index Back |
|---|---|
Self Service Name ChangeSearch record used for Name change PIA approval component |
| SELECT EMPLID , EMPL_RCD , ACTION_DT_SS , EFFSEQ , WF_STATUS , APPROVAL_REQUIRED FROM PS_HR_SALCHG_DAT WHERE APPROVAL_REQUIRED = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | ACTION_DT_SS |
Date(10) | DATE | Termination Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | WF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved |
| 6 | APPROVAL_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page.
N=No Approval Required Y=Approval Required Default Value: N |