SAD_TAC_MAP_CIT (SQL Table)	Index Back
TAC Citizenship Map This record is used to hold the mapping of the TAC Citizenship code to the PeopleSoft Citizenship Status and Residency.

SAD_TAC_MAP_CIT

(SQL Table)

TAC Citizenship Map

This record is used to hold the mapping of the TAC Citizenship code to the PeopleSoft Citizenship Status and Residency.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SAD_TAC_CIT_CD Character(2) VARCHAR2(2) NOT NULL TAC Citizen Code
1=(1) Australian Citizen
2=(2) NZ Citizen
3=(3) Permanent Resident
4=(4) Student/Temp Visa
5=(5) Resident Outside
8=(8) Permanent Humanitarian
A=Australian Citizen
B=New Zealand Citizen
C=Permanent Resident
C1=Australian
C2=New Zealand
C3=Perm Resident other than NZ
C4=Student Visa
C5=Other
C8=Permanent Humanitarian
D=Non Resident
N=Non Resident
Y=Australian Citizen

2 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
Prompt Table: CITIZEN_STS_TBL

3 RESIDENCY Character(5) VARCHAR2(5) NOT NULL Residency
Prompt Table: RESIDENCY_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAD_TAC_CIT_CD	Character(2)	VARCHAR2(2) NOT NULL	TAC Citizen Code 1=(1) Australian Citizen 2=(2) NZ Citizen 3=(3) Permanent Resident 4=(4) Student/Temp Visa 5=(5) Resident Outside 8=(8) Permanent Humanitarian A=Australian Citizen B=New Zealand Citizen C=Permanent Resident C1=Australian C2=New Zealand C3=Perm Resident other than NZ C4=Student Visa C5=Other C8=Permanent Humanitarian D=Non Resident N=Non Resident Y=Australian Citizen
2	CITIZENSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Citizenship Status Prompt Table: CITIZEN_STS_TBL
3	RESIDENCY	Character(5)	VARCHAR2(5) NOT NULL	Residency Prompt Table: RESIDENCY_TBL