| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
PSMPC_RECORD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Type "1" Report Header, "2" Report detail
|
| 2 |
PSMPC_AGS_NUMBER |
Character(20) |
VARCHAR2(20) NOT NULL |
The AGS Number issued for the current period of employment.
|
| 3 |
PSMPC_PREV_AGS_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
The AGS Number allocated to the employee for the most recent previous period of employment in APS.
|
| 4 |
PSMPC_GIVEN_NAMES |
Character(30) |
VARCHAR2(30) NOT NULL |
The given names of the employee.
|
| 5 |
PSMPC_SURNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The surname of the APS employee.
|
| 6 |
PSMPC_TITLE |
Character(4) |
VARCHAR2(4) NOT NULL |
The title of the APS employee.
|
| 7 |
PSMPC_BIRTHDATE |
Date(10) |
DATE |
The date of birth of the APS employee.
|
| 8 |
PSMPC_SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
The sex of the APS employee.
|
| 9 |
PSMPC_ETHNICITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether the APS employee is of Aboriginal or Torres Strait Islander origin.
|
| 10 |
PSMPC_BIRTHCOUNTRY |
Character(4) |
VARCHAR2(4) NOT NULL |
The country of birth of the APS employee.
|
| 11 |
PSMPC_ARRIVAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
The year the employee first arrived as a resident in Australia.
|
| 12 |
PSMPC_FIRST_LANG |
Number(1,0) |
SMALLINT NOT NULL |
The first language spoken by the APS employee.
|
| 13 |
PSMPC_NON_ENG_LANG |
Number(2,0) |
SMALLINT NOT NULL |
Main Non English Language
|
| 14 |
PSMPC_MOTHER_LANG |
Number(1,0) |
SMALLINT NOT NULL |
The first language spoken by the APS employee's mother.
|
| 15 |
PSMPC_FATHER_LANG |
Number(1,0) |
SMALLINT NOT NULL |
The first language spoken by the APS employee's father.
|
| 16 |
PSMPC_DISABILITY |
Number(2,0) |
SMALLINT NOT NULL |
Employee's disability.
|
| 17 |
PSMPC_EDUC_LEVEL |
Number(2,0) |
SMALLINT NOT NULL |
The highest level of education qualification completed by the APS employee.
|
| 18 |
PSMPC_MAJOR_STUDY |
Number(2,0) |
SMALLINT NOT NULL |
Main fields of study for the highest completed education qualification.
|
| 19 |
PSMPC_MINOR_STUDY |
Number(2,0) |
SMALLINT NOT NULL |
The main field of study for the highest completed education qualification.
|
| 20 |
PSMPC_YR_COMPLETE |
Number(4,0) |
SMALLINT NOT NULL |
The year the employee completed the highest attained education qualification.
|
| 21 |
PSMPC_EDUC_COUNTRY |
Number(1,0) |
SMALLINT NOT NULL |
Where the employee obtained their highest education qualification.
|
| 22 |
PSMPC_ENGAGE_DATE |
Date(10) |
DATE |
The date on which the APS employee was engaged in the APS for the current period of employment.
|
| 23 |
PSMPC_EMPLOY_STAT |
Number(2,0) |
SMALLINT NOT NULL |
The employment category under which the employee was engaged for the current period of employment.
|
| 24 |
PSMPC_STD_HOURS |
Number(5,0) |
INTEGER NOT NULL |
The regular number of hours the employee is paid to work in a standard week.
|
| 25 |
PSMPC_CLASS_MIN |
Character(2) |
VARCHAR2(2) NOT NULL |
Classification Group - minimum
|
| 26 |
PSMPC_CLASS_MAX |
Character(2) |
VARCHAR2(2) NOT NULL |
Classification Group - maximum
|
| 27 |
PSMPC_CONTACT_PH |
Character(10) |
VARCHAR2(10) NOT NULL |
Contact phone for the APS Employment DB project team to contact to clarify infor about the employee.
|
| 28 |
PSMPC_POSTCODE |
Number(4,0) |
SMALLINT NOT NULL |
The postcode of the APS employee's workplace location.
|
| 29 |
PSMPC_GROSS_REMUN |
Number(6,0) |
INTEGER NOT NULL |
The full-time equivalent value of the employee's annual gross remuneration package.
|
| 30 |
PSMPC_MOVEMENT_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
The change in status of an employee.
|
| 31 |
PSMPC_MOVEMENT_DT |
Date(10) |
DATE |
The commencement date of the movement for the APS employee.
|
| 32 |
PSMPC_MAT_LVE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies if the APS employee is on the 12 weeks compulsory maternity leave.
|
| 33 |
PSMPC_OPER_STATUS |
Number(1,0) |
SMALLINT NOT NULL |
The operative status of the APS employee.
|
| 34 |
PSMPC_PRIOR_EMPLOY |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies what the APS employee was doing prior to the current period of employment in the APS.
|
| 35 |
PSMPC_COMPLETE_DT |
Date(10) |
DATE |
The date of completing for temporary movements for the APS employee.
|
| 36 |
PSMPC_AGENCY_CODE |
Number(3,0) |
SMALLINT NOT NULL |
The employing Agency of the APS employee.
|