SCC_ADDR_H (SQL View)	Index Back
Person Addresses ADDRESSES contains effective dated history for personal addresses. Campus Solutions hollow view for the core DRIVERS_LIC table. Data is actually sourced from the Service Oriented Architecture. EFFDT removed as key so this record can be used as Current Address for each type without cascading a Rowset.EffDt property to lower level rowsets. Component ADDRESS_MAINT uses this at Level1 with SCC_ADDR_L2_H at Level2.

SCC_ADDR_H

(SQL View)

Person Addresses

ADDRESSES contains effective dated history for personal addresses. Campus Solutions hollow view for the core DRIVERS_LIC table. Data is actually sourced from the Service Oriented Architecture. EFFDT removed as key so this record can be used as Current Address for each type without cascading a Rowset.EffDt property to lower level rowsets. Component ADDRESS_MAINT uses this at Level1 with SCC_ADDR_L2_H at Level2.

SELECT ' ' , ' ' , %DateNull , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %DateTimeNull , ' ' FROM %Table(INSTALLATION_SA)

Parent record: HCR_PERSON_I

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
Default Value: INSTALLATION_CC.SCC_ADDRESS_TYPE
Prompt Table: HCR_ADDR_TYP_I

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: SCC_CNT_ADFMTVW

6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

8 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

9 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

10 CITY Character(30) VARCHAR2(30) NOT NULL City

11 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

12 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

13 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference

14 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

15 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

16 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

17 COUNTY Character(30) VARCHAR2(30) NOT NULL County

18 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

19 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

20 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

21 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

22 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1

23 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2

24 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3

25 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City

26 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

27 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.

28 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type Default Value: INSTALLATION_CC.SCC_ADDRESS_TYPE Prompt Table: HCR_ADDR_TYP_I
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: SCC_CNT_ADFMTVW
6	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
7	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
8	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
9	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
10	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
11	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
12	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
13	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
14	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
15	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
16	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
17	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
18	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
19	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
20	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
21	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
22	ADDRESS1_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 1
23	ADDRESS2_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 2
24	ADDRESS3_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 3
25	CITY_AC	Character(30)	VARCHAR2(30) NOT NULL	Alternate Character City
26	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
27	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.
28	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.