SAD_CA_LGGD_NLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAD_CA_TRANS_SEQ	Number(12,0)	DECIMAL(12) NOT NULL	Transaction Seq
2	SAD_CA_INDEX_ID	Character(40)	VARCHAR2(40) NOT NULL	CA-ChainID
3	SAD_CA_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Sequence number
4	SCC_TEMP_ID	Number(16,0)	DECIMAL(16) NOT NULL	Temp Constituent ID
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	SAD_CA_FIRST_NAME	Character(200)	VARCHAR2(200) NOT NULL	First name
7	SAD_CA_NAME_PREFIX	Character(20)	VARCHAR2(20) NOT NULL	Prefix Name
8	SAD_CA_LAST_NAME	Character(200)	VARCHAR2(200) NOT NULL	Last Name
9	SAD_CA_PHONE_NBR	Character(20)	VARCHAR2(20) NOT NULL	Phone Nbr Bug 35072228 - increased length to 20
10	SAD_CA_MOBILE_NBR	Character(20)	VARCHAR2(20) NOT NULL	Mobile Nbr Bug 35072228 - increased length to 20
11	SAD_CA_EMAIL_ADDR	Character(100)	VARCHAR2(100) NOT NULL	Email Address
12	SAD_CA_STREET_NLD	Character(200)	VARCHAR2(200) NOT NULL	Street
13	SAD_CA_NUM1_NLD	Character(20)	VARCHAR2(20) NOT NULL	Number 1
14	SAD_CA_NUM2_NLD	Character(20)	VARCHAR2(20) NOT NULL	Number 2
15	SAD_CA_NUM_ADD	Character(100)	VARCHAR2(100) NOT NULL	Address
16	SAD_CA_POSTAL_NLD	Character(6)	VARCHAR2(6) NOT NULL	Postal
17	SAD_CA_CITY_NLD	Character(200)	VARCHAR2(200) NOT NULL	City
18	SAD_CA_CNTRY_CODE	Character(4)	VARCHAR2(4) NOT NULL	Country Code
19	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
20	SAD_CA_ADDR_LINE1	Character(200)	VARCHAR2(200) NOT NULL	Address Line 1
21	SAD_CA_ADDR_LINE2	Character(200)	VARCHAR2(200) NOT NULL	Address Line2
22	SAD_CA_ADDR_LINE3	Character(200)	VARCHAR2(200) NOT NULL	Address Line 3