JOB_AUS_CV (SQL View)	Index Back
JOB_AUS MSG Clairvia Clone of JOB_AUS MSG record for Clairvia Fullsync message

JOB_AUS_CV

(SQL View)

JOB_AUS MSG Clairvia

Clone of JOB_AUS MSG record for Clairvia Fullsync message

SELECT AUS.EMPLID , AUS.EMPL_RCD , AUS.EFFDT , AUS.EFFSEQ , AUS.CASUAL_IND , AUS.SALARY_PACKAGED , AUS.PAYROLL_STATE_AUS , AUS.CLASSN_CURRENT_AUS , AUS.WORK_SECTOR_AUS , AUS.FUNCTION_AUS , AUS.ANN_CNTACT_HRS_AUS , AUS.TEACH_WEEKS_AUS , AUS.CASUAL_TYPE_AUS , AUS.TERM_TYPE_AUS , AUS.TERM_LTD_AUS FROM PS_JOB_AUS AUS , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = AUS.EMPLID AND ASG.EMPL_RCD = AUS.EMPL_RCD AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: JOB.EMPLID
Prompt Table: PER_ORG_ASGN

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Default Value: JOB.EMPL_RCD
Prompt Table: PER_ORG_ASGN

3 EFFDT Date(10) DATE Effective Date
Default Value: JOB.EFFDT

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
Default Value: JOB.EFFSEQ

5 CASUAL_IND Character(1) VARCHAR2(1) NOT NULL Casual Indicator
Y/N Table Edit
Default Value: N

6 SALARY_PACKAGED Character(1) VARCHAR2(1) NOT NULL Sal Package - Salary Packaged Flag
Y/N Table Edit
Default Value: N

7 PAYROLL_STATE_AUS Character(3) VARCHAR2(3) NOT NULL Sal Package - Payroll Tax State
Prompt Table: STATE_AUS_VW

8 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

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

10 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

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

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

13 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

14 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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: JOB.EMPLID Prompt Table: PER_ORG_ASGN
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: JOB.EMPL_RCD Prompt Table: PER_ORG_ASGN
3	EFFDT	Date(10)	DATE	Effective Date Default Value: JOB.EFFDT
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence Default Value: JOB.EFFSEQ
5	CASUAL_IND	Character(1)	VARCHAR2(1) NOT NULL	Casual Indicator Y/N Table Edit Default Value: N
6	SALARY_PACKAGED	Character(1)	VARCHAR2(1) NOT NULL	Sal Package - Salary Packaged Flag Y/N Table Edit Default Value: N
7	PAYROLL_STATE_AUS	Character(3)	VARCHAR2(3) NOT NULL	Sal Package - Payroll Tax State Prompt Table: STATE_AUS_VW
8	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
9	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)
10	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
11	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.
12	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.
13	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
14	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
15	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.