DETYA_PRCS_TMP (SQL Table)	Index Back
Temp tbl for DETYA Processing This Table stores the data created for the purpose of Australian Higher Education reporting purposes.

DETYA_PRCS_TMP

(SQL Table)

Temp tbl for DETYA Processing

This Table stores the data created for the purpose of Australian Higher Education 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 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

3 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

4 CLASSN_CURRENT_AUS Number(3,0) SMALLINT NOT NULL This field identifies the classification term and level for an employee in respect of their current duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
Prompt Table: DTYA_CURCLS_AUS

5 CURR_TERM_TYPE_AUS Character(2) VARCHAR2(2) NOT NULL This field refers to the type of appointment for an employee for the Processing period. This field is used in the temporary table that will store the data needed for the electronic file. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
00=Limited
81=Probationary
82=Confirmed
91=Other Term

6 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence

7 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

8 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)

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

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

11 CURR_TERM_LTD_AUS Number(2,0) SMALLINT NOT NULL This field refers to the possible duration of appointment for an employee for the processing period. Employees are hired on a limited duration basis are expected to record the duration for which they have been hired. This field is used in the temporary table that will store the data needed for the electronic file. This is an Australia specific code which is needed for DETYA electronic reporting purposes.

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

13 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

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

15 BIRTHDATE Date(10) DATE Date of Birth

16 TERM_TYPE_AUS Character(2) VARCHAR2(2) NOT NULL This field refers to the type of appointment for an employee. Employees are hired either on a limited, probation, confirmed or other terms. This is an Australian specific code which is needed for DETYA electronic reporting purposes.
00=Limited
81=Probationary
82=Confirmed
91=Other Term

17 TERM_LTD_AUS Number(2,0) SMALLINT NOT NULL This field refers to the possible duration of appointment for an employee. Employees are hired on a limited duration basis are expected to record the duration for which they have been hired. This is an Australian specific code which is needed for DETYA electronic reporting purposes.

18 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate

19 ETHNC_CTGY_AUS Character(1) VARCHAR2(1) NOT NULL This field identifies the Ethnic Category of the member of staff. The field appears on the temporary table that can be modified by the user before generating the electronic file. This is an Australia specific requirement needed for DETYA electronic reporting purposes.
2=Not of Aboriginal/T S Islander
3=Aboriginal Origin
4=Torres Strait Islander
5=Both Aboriginal & T S Islander
9=No Information

20 EDUC_LVL_AUS Character(1) VARCHAR2(1) NOT NULL This field refers to the highest education attained by the member of staff. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
0=Non-Academic
1=Higher Degree
2=Bachelor's Degree
3=Other
4=No Info

21 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.

22 INST_TYPE_AUS Character(1) VARCHAR2(1) NOT NULL This field identifies the place where the member of the staff received their highest education. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
0=Non-Academic
1=This Institute
2=Other Institute
3=Overseas Institute

23 EFFDT Date(10) DATE Effective Date
Default Value: %date

24 ANN_CNTACT_HRS_AUS Number(7,2) DECIMAL(6,2) NOT NULL This field represents the total number of hours spent annually in a teaching job. The field is used for calculating FTE equivalence. This is an Australia specific code which is needed for DETYA electronic reporting purposes.

25 TEACH_WEEKS_AUS Number(2,0) SMALLINT NOT NULL This field represents the total number of weeks worked by a member of staff in the role of teaching. The field is used for calculating FTE equivalence. This is an Australia specific code which is needed for DETYA electronic reporting purposes.

26 CASUAL_TYPE_AUS Character(1) VARCHAR2(1) NOT NULL This field translates the type of work performed by a member of the staff and is used for calculating FTE equivalence for casual types. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
L=Lecturing
R=Market/Research/Other
S=Supervise/Tutorial Workshop

27 DETYA_REP_TYPE Character(1) VARCHAR2(1) NOT NULL This field is used to identify the type of reporting being generated for DETYA purposes.
C=Casual Staff
S=Permanent Employee

28 ASOFDATE Date(10) DATE As of Date

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

#	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	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
3	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
4	CLASSN_CURRENT_AUS	Number(3,0)	SMALLINT NOT NULL	This field identifies the classification term and level for an employee in respect of their current duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes. Prompt Table: DTYA_CURCLS_AUS
5	CURR_TERM_TYPE_AUS	Character(2)	VARCHAR2(2) NOT NULL	This field refers to the type of appointment for an employee for the Processing period. This field is used in the temporary table that will store the data needed for the electronic file. This is an Australia specific code which is needed for DETYA electronic reporting purposes. 00=Limited 81=Probationary 82=Confirmed 91=Other Term
6	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
7	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
8	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)
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
11	CURR_TERM_LTD_AUS	Number(2,0)	SMALLINT NOT NULL	This field refers to the possible duration of appointment for an employee for the processing period. Employees are hired on a limited duration basis are expected to record the duration for which they have been hired. This field is used in the temporary table that will store the data needed for the electronic file. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
12	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
13	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
14	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
15	BIRTHDATE	Date(10)	DATE	Date of Birth
16	TERM_TYPE_AUS	Character(2)	VARCHAR2(2) NOT NULL	This field refers to the type of appointment for an employee. Employees are hired either on a limited, probation, confirmed or other terms. This is an Australian specific code which is needed for DETYA electronic reporting purposes. 00=Limited 81=Probationary 82=Confirmed 91=Other Term
17	TERM_LTD_AUS	Number(2,0)	SMALLINT NOT NULL	This field refers to the possible duration of appointment for an employee. Employees are hired on a limited duration basis are expected to record the duration for which they have been hired. This is an Australian specific code which is needed for DETYA electronic reporting purposes.
18	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
19	ETHNC_CTGY_AUS	Character(1)	VARCHAR2(1) NOT NULL	This field identifies the Ethnic Category of the member of staff. The field appears on the temporary table that can be modified by the user before generating the electronic file. This is an Australia specific requirement needed for DETYA electronic reporting purposes. 2=Not of Aboriginal/T S Islander 3=Aboriginal Origin 4=Torres Strait Islander 5=Both Aboriginal & T S Islander 9=No Information
20	EDUC_LVL_AUS	Character(1)	VARCHAR2(1) NOT NULL	This field refers to the highest education attained by the member of staff. This is an Australia specific code which is needed for DETYA electronic reporting purposes. 0=Non-Academic 1=Higher Degree 2=Bachelor's Degree 3=Other 4=No Info
21	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.
22	INST_TYPE_AUS	Character(1)	VARCHAR2(1) NOT NULL	This field identifies the place where the member of the staff received their highest education. This is an Australia specific code which is needed for DETYA electronic reporting purposes. 0=Non-Academic 1=This Institute 2=Other Institute 3=Overseas Institute
23	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
24	ANN_CNTACT_HRS_AUS	Number(7,2)	DECIMAL(6,2) NOT NULL	This field represents the total number of hours spent annually in a teaching job. The field is used for calculating FTE equivalence. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
25	TEACH_WEEKS_AUS	Number(2,0)	SMALLINT NOT NULL	This field represents the total number of weeks worked by a member of staff in the role of teaching. The field is used for calculating FTE equivalence. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
26	CASUAL_TYPE_AUS	Character(1)	VARCHAR2(1) NOT NULL	This field translates the type of work performed by a member of the staff and is used for calculating FTE equivalence for casual types. This is an Australia specific code which is needed for DETYA electronic reporting purposes. L=Lecturing R=Market/Research/Other S=Supervise/Tutorial Workshop
27	DETYA_REP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify the type of reporting being generated for DETYA purposes. C=Casual Staff S=Permanent Employee
28	ASOFDATE	Date(10)	DATE	As of Date
29	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company