PRESENCE_TBL

(SQL Table)
Index Back

Substantial Presence Table

Substantial Presence Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
3 DAYS_CURRENT Number(3,0) SMALLINT NOT NULL Days Current
4 DAYS_PRIOR1 Number(3,0) SMALLINT NOT NULL Days Prior 1
5 DAYS_PRIOR2 Number(3,0) SMALLINT NOT NULL Days Prior2
6 ALIEN_REG Character(1) VARCHAR2(1) NOT NULL Alien Registration

Y/N Table Edit

Default Value: N

7 DAYS_FLAG Character(1) VARCHAR2(1) NOT NULL 31 Days Flag

Y/N Table Edit

Default Value: N

8 PASSED Character(1) VARCHAR2(1) NOT NULL Passed Test

Y/N Table Edit

Default Value: N