HR_I9_1_TAO (SQL Table)	Index Back
Expiration Rpt Temp table Temp table used for the process to create the I9 Receipt and Expiration Tracking report.

HR_I9_1_TAO

(SQL Table)

Expiration Rpt Temp table

Temp table used for the process to create the I9 Receipt and Expiration Tracking report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 I9_EE_SIGN_DT Date(10) DATE Employee Sign Date

4 I9_XLATLONG_A Character(70) VARCHAR2(70) NOT NULL

5 I9_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Doc Type
A=List A
B=List B AND List C

6 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number

7 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

8 NAME Character(50) VARCHAR2(50) NOT NULL Name

9 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

10 HIRE_DT Date(10) DATE First Start Date

11 I9_UPDATE_DOC_FLG Character(1) VARCHAR2(1) NOT NULL Application Update flag

12 I9_EXP_DOC_FLG Character(1) VARCHAR2(1) NOT NULL Expired Docs flag

13 I9_DOC_EXP_DT_A1 Date(10) DATE Exp. Date (if any)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	I9_EE_SIGN_DT	Date(10)	DATE	Employee Sign Date
4	I9_XLATLONG_A	Character(70)	VARCHAR2(70) NOT NULL
5	I9_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Doc Type A=List A B=List B AND List C
6	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
7	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
8	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
9	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
10	HIRE_DT	Date(10)	DATE	First Start Date
11	I9_UPDATE_DOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Application Update flag
12	I9_EXP_DOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Expired Docs flag
13	I9_DOC_EXP_DT_A1	Date(10)	DATE	Exp. Date (if any)