DETYA_PRCS_TMP(SQL Table) |
Index Back |
|---|---|
Temp tbl for DETYA ProcessingThis 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 Rcd Nbr |
| 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 X=Indeterminate/Intersex/Unspec |
| 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 |