APS_CNTRY_AUS (SQL Table)	Index Back
AUS - APS Country Codes Australian Public Service maintains their internal codes for countries, which are not the same as the ISO codes. These codes are required to maintain the Birth Country of the employees. APS customers must maintain the APS code and can associate it to the ISO code.

APS_CNTRY_AUS

(SQL Table)

AUS - APS Country Codes

Australian Public Service maintains their internal codes for countries, which are not the same as the ISO codes. These codes are required to maintain the Birth Country of the employees. APS customers must maintain the APS code and can associate it to the ISO code.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
2	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.