SCC_STG_RLSHIPS

#	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	RELATIONSHIP_NBR	Number(2,0)	SMALLINT NOT NULL	Relationship Nbr
3	PEOPLE_RELATION	Character(2)	VARCHAR2(2) NOT NULL	Relationship Default Value: NI
4	GUARDIAN_RELATIONS	Character(2)	VARCHAR2(2) NOT NULL	Guardian Relationship LG=Legal Guardian NA=Not Applicable OT=Other PG=Parent Guardian SG=Self Guardian XG=Primary Guardian Default Value: NA
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	EMPLID_RELATED	Character(11)	VARCHAR2(11) NOT NULL	Related People ID Prompt Table: PEOPLE_SRCH
7	RELATION_NBR_RCP	Number(2,0)	SMALLINT NOT NULL	Reciprocal Relationship Number
8	HIGHEST_EDUC_LVL	Character(2)	VARCHAR2(2) NOT NULL	Highest Education Level
9	GUARDIAN_OCC	Character(10)	VARCHAR2(10) NOT NULL	Guardian Occupation Prompt Table: US_SOC_TBL
10	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: EXT_ORG_TBL
11	EMPLOYER	Character(30)	VARCHAR2(30) NOT NULL	Employer
12	RELATIONS_INCOME	Number(9,0)	DECIMAL(9) NOT NULL	Relations Income
13	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed
14	RESIDENCY_DT	Date(10)	DATE	Residency Date
15	STATE_RESIDENCY	Character(6)	VARCHAR2(6) NOT NULL	State of Residency Prompt Table: STATE_RES_VW
16	COUNTRY_RESIDENCY	Character(3)	VARCHAR2(3) NOT NULL	Country of Residency Default Value: INSTALLATION.COUNTRY Prompt Table: COUNTRY_TBL
17	NID_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	National ID Country Prompt Table: SCC_NIDCTY_VW
18	NATIONAL_ID_TYPE	Character(6)	VARCHAR2(6) NOT NULL	National ID Type Prompt Table: REL_NID_TYPE_VW
19	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
20	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
21	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: SCC_CNT_ADFMTVW
22	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
23	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
24	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
25	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
26	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
27	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
28	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
29	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
30	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
31	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
32	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
33	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
34	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
35	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
36	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
37	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
38	CHG_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Address Changed Y/N Table Edit Default Value: N
39	CHG_OTHER	Character(1)	VARCHAR2(1) NOT NULL	Other Changed Y/N Table Edit Default Value: N
40	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix Prompt Table: HCR_NM_PREFIX_I
41	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix Prompt Table: HCR_NM_SUFFIX_I
42	SALUTATION	Character(20)	VARCHAR2(20) NOT NULL	Salutation Prompt Table: SALUTATION_TBL
43	CONTACT_THRU	Number(2,0)	SMALLINT NOT NULL	Contact Thru
44	PHONE_DAY	Character(30)	VARCHAR2(30) NOT NULL	Daytime Telephone
45	PHONE_EVE	Character(30)	VARCHAR2(30) NOT NULL	Evening Telephone
46	PHONE_FAX	Character(30)	VARCHAR2(30) NOT NULL	Fax Nbr
47	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
48	URL_ADDRESS	Character(254)	VARCHAR2(254) NOT NULL	URL Address
49	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
50	CITIZEN_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country of Citizenship Prompt Table: COUNTRY_TBL
51	CITIZENSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Citizenship Status Prompt Table: SCC_CTZN_STS_I Set Control Field: CITIZEN_COUNTRY
52	ALL_COMMUNICATIONS	Character(1)	VARCHAR2(1) NOT NULL	All Communications Y/N Table Edit Default Value: N
53	COMMENTS	Long Character	CLOB	Comment
54	JOINT_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Create Joint Records Y/N Table Edit Default Value: N
55	JOINT_ADDRESS	Character(1)	VARCHAR2(1) NOT NULL	Joint Address Y/N Table Edit Default Value: N
56	JOINT_ADDRESS_RCP	Character(1)	VARCHAR2(1) NOT NULL	Joint Address Y/N Table Edit Default Value: N
57	ADDR_TYPE3	Character(4)	VARCHAR2(4) NOT NULL	Address Type
58	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type
59	DISSOLVE_REASON	Character(2)	VARCHAR2(2) NOT NULL	Dissolution Reason DI=Divorce DP=Deceased Partner LA=Leave of Absence LD=Long Term Disability MV=Move OT=Other PR=Per Request SP=Separation
60	E_ADDR_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR. BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other
61	E_ADDR_TYP2	Character(4)	VARCHAR2(4) NOT NULL	Email Address Type BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other PREF=Preferred Prompt Table: RELATED_EADDR_V
62	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country Prompt Table: COUNTRY_TBL
63	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
64	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
65	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
66	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time