| # |
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 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
|
| 15 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 16 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 17 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 18 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 19 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 20 |
BIRTHCOUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Birth Country
|
| 21 |
APS_MOVE_CD_AUS |
Character(3) |
VARCHAR2(3) NOT NULL |
This field identifies the employees change in employment status in the organization.
|
| 22 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 23 |
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.
|
| 24 |
APS_OPERATIVE_STAT |
Number(1,0) |
SMALLINT NOT NULL |
Operative Status of the Australian Public Service (APS) employee.
|