EFFDTDefault Value: %date
A=Approved
D=Denied
I=Draft
M=Pushed Back
N=New Submission
P=Pending Approval
S=Submitted
HR_I9_RQSTS_VW(SQL View) |
Index Back |
|---|---|
I9 Requests for ApprovalsI9 Requests for Approvals |
| SELECT A.EMPLID ,A.EFFDT ,A.EFFSEQ ,A.EFFDT ,'N' ,%DateAdd(%DateIn(A.HIRE_DT) ,3) ,' ' ,D.DESCR ,A.HIRE_DT ,' ' FROM PS_HR_I9_PERSON A , PS_PRIMARY_JOB_VW J , PS_DEPT_TBL D WHERE A.EMPLID=J.EMPLID AND J.EFFDT<=A.EFFDT AND D.DEPTID=J.DEPTID AND D.SETID = J.SETID_DEPT AND D.EFFDT<=J.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 4 | I9_SUB_DATE | Date(10) | DATE | Effective Date |
| 5 | I9_SUB_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
I9 status
A=Approved D=Denied I=Draft M=Pushed Back N=New Submission P=Pending Approval S=Submitted |
| 6 | I9_FILING_DUE_DT | Date(10) | DATE | Alien Authorization Date |
| 7 | DUE_IN_TEXT | Character(50) | VARCHAR2(50) NOT NULL | Due In |
| 8 | DEPTNAME | Character(30) | VARCHAR2(30) NOT NULL | Department Name |
| 9 | LAST_HIRE_DT | Date(10) | DATE | Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD. |
| 10 | I9_SUB_DATE_STR | Character(15) | VARCHAR2(15) NOT NULL | Effective Date |