FULL_TIME_TAO

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

5 WORK_SECTOR_AUS Character(1) VARCHAR2(1) NOT NULL The work sector in which a function is being performed in one organisational unit by a member of staff in respect of their current duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
1=Higher Education
2=TAFE
3=VET (AMC Only)

6 ORG_UNIT_AUS Character(4) VARCHAR2(4) NOT NULL This code represents a unique organisational unit in which a member of the staff will perform their duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	WORK_SECTOR_AUS	Character(1)	VARCHAR2(1) NOT NULL	The work sector in which a function is being performed in one organisational unit by a member of staff in respect of their current duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes. 1=Higher Education 2=TAFE 3=VET (AMC Only)
6	ORG_UNIT_AUS	Character(4)	VARCHAR2(4) NOT NULL	This code represents a unique organisational unit in which a member of the staff will perform their duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes.