HRAU_PSMPC_TAO (SQL Table)	Index Back
PSMPC Reporting temp table This temporary table is used to generate output file for the Australian Public Service PSMPC report.

HRAU_PSMPC_TAO

(SQL Table)

PSMPC Reporting temp table

This temporary table is used to generate output file for the Australian Public Service PSMPC report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

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

5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

6 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours

7 EXPECTED_END_DATE Date(10) DATE Expected End Date of a job.

8 APS_AGENT_CD_AUS Number(3,0) SMALLINT NOT NULL Australia Public Service (APS) Agency Code.

9 APS_MIN_CLS_AUS Character(2) VARCHAR2(2) NOT NULL This field is associated with the APS grouping that is used for reporting purposes.
01=APS Group 1
02=APS Group 2
03=APS Group 3
04=APS Group 4
05=APS Group 5
06=APS Group 6
07=APS Group 7
08=APS Group 8
09=APS Group 9
10=APS Group 10
11=APS Group 11
51=Agency Head
60=APS Trainee

10 APS_MAX_CLS_AUS Character(2) VARCHAR2(2) NOT NULL This field is associated with the APS grouping that is used for reporting purposes.
01=APS Group 1
02=APS Group 2
03=APS Group 3
04=APS Group 4
05=APS Group 5
06=APS Group 6
07=APS Group 7
08=APS Group 8
09=APS Group 9
10=APS Group 10
11=APS Group 11
51=Agency Head
60=APS Trainee

11 APS_EMPLSTAT_AUS Character(2) VARCHAR2(2) NOT NULL This field identifies the employment category under which the employee was engaged for the current period of employment.
01=Ongoing Employee
09=Non Ongoing - Specific Term
10=Non Ongoing - Specific Task
11=Non Ongoing - Irregular Duties

12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

13 APS_ENGAGE_DT_AUS Date(10) DATE The date on which the employee joins an APS service needs to be reported. This date is not the same as the Hire date on JOB record as an employee might be transferred from another public service into the current organization.

14 APS_PREV_IND_AUS Character(2) VARCHAR2(2) NOT NULL For the purpose of APS reporting, it is necessary to the type of industry in which an employee worked in their previous jobs. This information is used for reporting purposes.
01=Private Sector
02=Commonwealth Public Sector
03=State/Local Govt Public Sector
04=Tertiary Education Institution
05=Self Employed
06=Employed in Other Sectors
07=Attending Educatn Institution
08=Unemployed
09=Other
97=Choose not to Give

15 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

16 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

17 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

18 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME

19 BIRTHDATE Date(10) DATE Date of Birth

20 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

21 APS_CNTRY_AUS Number(4,0) SMALLINT NOT NULL This is the Australia Public Service (APS) country code. The APS maintains a separate list of country code that is not the same as the standard ISO codes. This list must be maintained for reporting purposes.

22 APS_MOVE_CD_AUS Character(3) VARCHAR2(3) NOT NULL This field identifies the employees change in employment status in the organization.

23 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate

24 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

25 APS_PREV_AGS_AUS Character(20) VARCHAR2(20) NOT NULL Previous AGS Number

26 APS_ENTRY_YR_AUS Number(4,0) SMALLINT NOT NULL The date on which the employee arrived in Australia. This field is used by the Australian Public Service for the purpose of reporting. The information is not neede if the employee was born in Australia.

27 ETHNIC_CATEGORY Character(1) VARCHAR2(1) NOT NULL Ethnic Category
1=White
2=Black
3=Hispanic
4=Asian/Pacific Islander
5=American Indian/Alaskan Native
6=Not Applicable
7=Chinese
9=Indian
A=Aboriginal/Torres Strait Islnd
B=Aboriginal Origin
C=Torres Strait Islander Origin
E=Eurasian
I=Irianese
M=Malay
O=Maori
P=Pacific Islander

28 APS_EE_LNG_AUS Character(1) VARCHAR2(1) NOT NULL This field refers to the employee's 1st language spoken. For the purpose of APS reporting. It is required to know the primary language of the employee.
1=English Only
2=English & another Language
3=Language other than English
4=Chose not to give

29 APS_EE_LNG_CD_AUS Number(2,0) SMALLINT NOT NULL The APS maintains an internal code for the language of their employees. This field records the primary non-English language code of the employees whose primary language is other than English.

30 APS_MTHR_LNG_AUS Character(1) VARCHAR2(1) NOT NULL This field refers to the mother's 1st language spoken. For the purpose of APS reporting, it is required to know the primary language of mother and father.
1=English Only
2=English & another Language
3=Language other than English
4=Language Unknown
7=Chose not to give

31 APS_FTHR_LNG_AUS Character(1) VARCHAR2(1) NOT NULL This field refers to the father's 1st language spoken. For the purpose of APS reporting, it is required to know the primary language of mother and father.
1=English Only
2=English & another Language
3=Language other than English
4=Language Unknown
7=Chose not to give

32 APS_DISAB_AUS Number(2,0) SMALLINT NOT NULL This field contains the APS equivalent code to describe the disability details of employees. The field is attached to the temporary table that will be populated by an AE program.

33 APS_EDUC_LVL_AUS Character(2) VARCHAR2(2) NOT NULL This field is required to capture the highest education received by an APS employee. As the highest education can be from a school or a degree, the data processing must identify the highest from different sources. This field is only used on the temporary table for reporting purpose.

34 APS_MAJOR_CD_AUS Character(2) VARCHAR2(2) NOT NULL APS Major Code

35 APS_MINOR_CD_AUS Character(2) VARCHAR2(2) NOT NULL The APS maintains an internal coding system to identify the minor degree earned by employees. This field is used only on the temporary table.
01=Administration
02=Accountancy
03=Economics
04=Finance/Banking
05=HRM/Industrial Relation
06=Education
07=Information Technology
08=Legal
09=Medical
10=Social Sciences
11=Science
12=Engg.Architect & Surveying
13=Arts
14=Business
15=Agriculture, Forestry
16=Trades, Labour & Hospitality
17=Others
97=Chose not to Give

36 APS_EDUC_CNTRY_FLG Character(1) VARCHAR2(1) NOT NULL This field is required to capture the Country where an employee received their education. APS coding guidelines need to be followed, therefore the Country code from school education or higher education must be translated into APS code. This field is needed only on the temporary table that is used by the AE program.

37 APS_MLEAVE_IND Number(1,0) SMALLINT NOT NULL Identifies if the Australian Public Service (APS) employee is on the 12 weeks compulsory maternity leave.

38 APS_OPERATIVE_STAT Number(1,0) SMALLINT NOT NULL Operative Status of the Australian Public Service (APS) employee.

39 DUTIES_TYPE Character(2) VARCHAR2(2) NOT NULL The type of duties for Temporary Assignments.

40 ASSIGNMENT_ID Number(8,0) INTEGER NOT NULL This is a system assigned number solely for Temporary Assignment jobs. It is used as a link between the Temporary Assignment job row and its respective Substantive job that is temporarily put on hold.

41 DATE_ACQUIRED Date(10) DATE Date Acquired

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
7	EXPECTED_END_DATE	Date(10)	DATE	Expected End Date of a job.
8	APS_AGENT_CD_AUS	Number(3,0)	SMALLINT NOT NULL	Australia Public Service (APS) Agency Code.
9	APS_MIN_CLS_AUS	Character(2)	VARCHAR2(2) NOT NULL	This field is associated with the APS grouping that is used for reporting purposes. 01=APS Group 1 02=APS Group 2 03=APS Group 3 04=APS Group 4 05=APS Group 5 06=APS Group 6 07=APS Group 7 08=APS Group 8 09=APS Group 9 10=APS Group 10 11=APS Group 11 51=Agency Head 60=APS Trainee
10	APS_MAX_CLS_AUS	Character(2)	VARCHAR2(2) NOT NULL	This field is associated with the APS grouping that is used for reporting purposes. 01=APS Group 1 02=APS Group 2 03=APS Group 3 04=APS Group 4 05=APS Group 5 06=APS Group 6 07=APS Group 7 08=APS Group 8 09=APS Group 9 10=APS Group 10 11=APS Group 11 51=Agency Head 60=APS Trainee
11	APS_EMPLSTAT_AUS	Character(2)	VARCHAR2(2) NOT NULL	This field identifies the employment category under which the employee was engaged for the current period of employment. 01=Ongoing Employee 09=Non Ongoing - Specific Term 10=Non Ongoing - Specific Task 11=Non Ongoing - Irregular Duties
12	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
13	APS_ENGAGE_DT_AUS	Date(10)	DATE	The date on which the employee joins an APS service needs to be reported. This date is not the same as the Hire date on JOB record as an employee might be transferred from another public service into the current organization.
14	APS_PREV_IND_AUS	Character(2)	VARCHAR2(2) NOT NULL	For the purpose of APS reporting, it is necessary to the type of industry in which an employee worked in their previous jobs. This information is used for reporting purposes. 01=Private Sector 02=Commonwealth Public Sector 03=State/Local Govt Public Sector 04=Tertiary Education Institution 05=Self Employed 06=Employed in Other Sectors 07=Attending Educatn Institution 08=Unemployed 09=Other 97=Choose not to Give
15	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
16	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
17	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
18	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
19	BIRTHDATE	Date(10)	DATE	Date of Birth
20	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
21	APS_CNTRY_AUS	Number(4,0)	SMALLINT NOT NULL	This is the Australia Public Service (APS) country code. The APS maintains a separate list of country code that is not the same as the standard ISO codes. This list must be maintained for reporting purposes.
22	APS_MOVE_CD_AUS	Character(3)	VARCHAR2(3) NOT NULL	This field identifies the employees change in employment status in the organization.
23	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
24	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
25	APS_PREV_AGS_AUS	Character(20)	VARCHAR2(20) NOT NULL	Previous AGS Number
26	APS_ENTRY_YR_AUS	Number(4,0)	SMALLINT NOT NULL	The date on which the employee arrived in Australia. This field is used by the Australian Public Service for the purpose of reporting. The information is not neede if the employee was born in Australia.
27	ETHNIC_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Ethnic Category 1=White 2=Black 3=Hispanic 4=Asian/Pacific Islander 5=American Indian/Alaskan Native 6=Not Applicable 7=Chinese 9=Indian A=Aboriginal/Torres Strait Islnd B=Aboriginal Origin C=Torres Strait Islander Origin E=Eurasian I=Irianese M=Malay O=Maori P=Pacific Islander
28	APS_EE_LNG_AUS	Character(1)	VARCHAR2(1) NOT NULL	This field refers to the employee's 1st language spoken. For the purpose of APS reporting. It is required to know the primary language of the employee. 1=English Only 2=English & another Language 3=Language other than English 4=Chose not to give
29	APS_EE_LNG_CD_AUS	Number(2,0)	SMALLINT NOT NULL	The APS maintains an internal code for the language of their employees. This field records the primary non-English language code of the employees whose primary language is other than English.
30	APS_MTHR_LNG_AUS	Character(1)	VARCHAR2(1) NOT NULL	This field refers to the mother's 1st language spoken. For the purpose of APS reporting, it is required to know the primary language of mother and father. 1=English Only 2=English & another Language 3=Language other than English 4=Language Unknown 7=Chose not to give
31	APS_FTHR_LNG_AUS	Character(1)	VARCHAR2(1) NOT NULL	This field refers to the father's 1st language spoken. For the purpose of APS reporting, it is required to know the primary language of mother and father. 1=English Only 2=English & another Language 3=Language other than English 4=Language Unknown 7=Chose not to give
32	APS_DISAB_AUS	Number(2,0)	SMALLINT NOT NULL	This field contains the APS equivalent code to describe the disability details of employees. The field is attached to the temporary table that will be populated by an AE program.
33	APS_EDUC_LVL_AUS	Character(2)	VARCHAR2(2) NOT NULL	This field is required to capture the highest education received by an APS employee. As the highest education can be from a school or a degree, the data processing must identify the highest from different sources. This field is only used on the temporary table for reporting purpose.
34	APS_MAJOR_CD_AUS	Character(2)	VARCHAR2(2) NOT NULL	APS Major Code
35	APS_MINOR_CD_AUS	Character(2)	VARCHAR2(2) NOT NULL	The APS maintains an internal coding system to identify the minor degree earned by employees. This field is used only on the temporary table. 01=Administration 02=Accountancy 03=Economics 04=Finance/Banking 05=HRM/Industrial Relation 06=Education 07=Information Technology 08=Legal 09=Medical 10=Social Sciences 11=Science 12=Engg.Architect & Surveying 13=Arts 14=Business 15=Agriculture, Forestry 16=Trades, Labour & Hospitality 17=Others 97=Chose not to Give
36	APS_EDUC_CNTRY_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field is required to capture the Country where an employee received their education. APS coding guidelines need to be followed, therefore the Country code from school education or higher education must be translated into APS code. This field is needed only on the temporary table that is used by the AE program.
37	APS_MLEAVE_IND	Number(1,0)	SMALLINT NOT NULL	Identifies if the Australian Public Service (APS) employee is on the 12 weeks compulsory maternity leave.
38	APS_OPERATIVE_STAT	Number(1,0)	SMALLINT NOT NULL	Operative Status of the Australian Public Service (APS) employee.
39	DUTIES_TYPE	Character(2)	VARCHAR2(2) NOT NULL	The type of duties for Temporary Assignments.
40	ASSIGNMENT_ID	Number(8,0)	INTEGER NOT NULL	This is a system assigned number solely for Temporary Assignment jobs. It is used as a link between the Temporary Assignment job row and its respective Substantive job that is temporarily put on hold.
41	DATE_ACQUIRED	Date(10)	DATE	Date Acquired