DETYA_PRCS_CA (SQL Table)	Index Back
DETYA table for Casuals This table stores the casual employee's data just before the electronic file is generated.

DETYA_PRCS_CA

(SQL Table)

DETYA table for Casuals

This table stores the casual employee's data just before the electronic file is generated.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW

2 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown

3 CLSN_GRP_AUS Character(2) VARCHAR2(2) NOT NULL This field identifies the classification type and level group for an employee in respect to their current duties. The value will be derived from the Duties classification field. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
01=Above Senior Lecturer
02=Level C
03=Level B
04=Level A
11=Non Academic

4 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.
Prompt Table: DTYA_ORGUNT_AUS

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 FUNCTION_AUS Character(1) VARCHAR2(1) NOT NULL This field refers to the role performed by the employee. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
1=Teaching only function
2=Research only function
3=Teaching & Research function
4=Other function

7 PRIOR_YR_FTE Number(4,0) SMALLINT NOT NULL This field represents the Full time equivalance of an employee in the year prior to the processing period. The value is based on a specific calculation provided by DETYA. 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPERATOR_VW
2	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
3	CLSN_GRP_AUS	Character(2)	VARCHAR2(2) NOT NULL	This field identifies the classification type and level group for an employee in respect to their current duties. The value will be derived from the Duties classification field. This is an Australia specific code which is needed for DETYA electronic reporting purposes. 01=Above Senior Lecturer 02=Level C 03=Level B 04=Level A 11=Non Academic
4	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. Prompt Table: DTYA_ORGUNT_AUS
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	FUNCTION_AUS	Character(1)	VARCHAR2(1) NOT NULL	This field refers to the role performed by the employee. This is an Australia specific code which is needed for DETYA electronic reporting purposes. 1=Teaching only function 2=Research only function 3=Teaching & Research function 4=Other function
7	PRIOR_YR_FTE	Number(4,0)	SMALLINT NOT NULL	This field represents the Full time equivalance of an employee in the year prior to the processing period. The value is based on a specific calculation provided by DETYA. This is an Australia specific code which is needed for DETYA electronic reporting purposes.