SCC_STG_NID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_TEMP_ID	Number(16,0)	DECIMAL(16) NOT NULL	Temp Constituent ID
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: NID_TYPE_VW
3	NATIONAL_ID_TYPE	Character(6)	VARCHAR2(6) NOT NULL	National ID Type Default Value: NID_TYPE2_VW.NATIONAL_ID_TYPE Prompt Table: NID_TYPE1_VW
4	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
5	SSN_KEY_FRA	Character(2)	VARCHAR2(2) NOT NULL	Social Security # Key
6	PRIMARY_NID	Character(1)	VARCHAR2(1) NOT NULL	Primary ID Y/N Table Edit Default Value: N
7	TAX_REF_ID_SGP	Character(1)	VARCHAR2(1) NOT NULL	Tax Reference Id - Singapore
8	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %datetime
9	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
11	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
12	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
13	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time