HCSCM_NIDTYPSTG (SQL Table)	Index Back
National ID Type staging table National ID type staging table used for storing National ID mask format System data. PODC AppEngine program will load National ID mask format from staging table to NID_TYPE_TBL

HCSCM_NIDTYPSTG

(SQL Table)

National ID Type staging table

National ID type staging table used for storing National ID mask format System data. PODC AppEngine program will load National ID mask format from staging table to NID_TYPE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

2 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

3 HCSCM_NIDMASK_FMT Character(30) VARCHAR2(30) NOT NULL Masking Format for National ID type

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
2	NATIONAL_ID_TYPE	Character(6)	VARCHAR2(6) NOT NULL	National ID Type
3	HCSCM_NIDMASK_FMT	Character(30)	VARCHAR2(30) NOT NULL	Masking Format for National ID type