HR_I9_DOC_EXP_V

(SQL View)
 Index Back

I9 Documents

I9 Documents

select EMPLID, EFFDT, EFFSEQ, I9_DOCTITLE_A, I9_DOCTITLE_A2, I9_DOCTITLE_A3, I9_DOCTITLE_B, I9_DOCTITLE_C, I9_DOC_EXP_DT_A1, I9_DOC_EXP_DT_A2, I9_DOC_EXP_DT_A3, I9_DOC_EXP_DT_B, I9_DOC_EXP_DT_C from PS_HR_I9_PERSON

# 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_DOCTITLE_A Character(50) VARCHAR2(50) NOT NULL Document Title
5 I9_DOCTITLE_A2 Character(50) VARCHAR2(50) NOT NULL Document Title
6 I9_DOCTITLE_A3 Character(50) VARCHAR2(50) NOT NULL Document Title
7 I9_DOCTITLE_B Character(50) VARCHAR2(50) NOT NULL Document Title
8 I9_DOCTITLE_C Character(50) VARCHAR2(50) NOT NULL Document Title
9 I9_DOC_EXP_DT_A1 Date(10) DATE Exp. Date (if any)
10 I9_DOC_EXP_DT_A2 Date(10) DATE Exp. Date (if any)
11 I9_DOC_EXP_DT_A3 Date(10) DATE Exp. Date (if any)
12 I9_DOC_EXP_DT_B Date(10) DATE Exp. Date (if any)
13 I9_DOC_EXP_DT_C Date(10) DATE Exp. Date (if any)