EMPLIDEFFDTDefault Value: %date
EFFSEQA=Approved
D=Denied
I=Draft
M=Pushed Back
P=Pending Approval
Q=I9 Verified- Not Approved
R=I9 Reverified
S=Submitted
T=New Document - Pending Approva
U=New Document Submitted
V=Completed
X=Not Started
HR_I9_EXP_VW(SQL View) |
Index Back |
|---|---|
I9 Older than 3 yearsI9 Older than 3 years |
| SELECT A.EMPLID , A.EFFDT , A.EFFSEQ , A.I9_STATUS FROM PS_HR_I9_PERSON A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_HR_I9_PERSON A1 WHERE A1.EMPLID = A.EMPLID) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_HR_I9_PERSON A2 WHERE A2.EMPLID = A.EMPLID AND A2.EFFDT = A.EFFDT) AND %DateDiff(A.EFFDT,%Currentdatein) > 1095 |
| # | 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_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
I9 status
A=Approved D=Denied I=Draft M=Pushed Back P=Pending Approval Q=I9 Verified- Not Approved R=I9 Reverified S=Submitted T=New Document - Pending Approva U=New Document Submitted V=Completed X=Not Started |