HR_RWOTHADDR_VW (SQL View)	Index Back
Remote Worker Home Address Remote Worker Home Address

HR_RWOTHADDR_VW

(SQL View)

Remote Worker Home Address

SELECT R.EMPLID ,R.EMPL_RCD ,'O' ,'A' ,%subrec(ADDRESS_SBR, R) ,R.start_date ,CASE WHEN R.LAST_UPDATE_DTTM IS NOT NULL THEN R.LAST_UPDATE_DTTM ELSE %CurrentDateTimeIn END FROM PS_HR_RWORK_TBL R where R.HR_RW_LOC_TYPE='O' AND (R.START_DATE IS NULL OR R.START_DATE=( SELECT MAX(START_DATE) FROM PS_HR_RWORK_TBL R1 WHERE R.EMPLID=R1.EMPLID AND R.EMPL_RCD=R1.EMPL_RCD AND R1.START_DATE <= %CurrentDateIn) ) AND (R.END_DATE IS NULL OR R.END_DATE >= %CurrentDateIn )

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
Prompt Table: ADDRESS_TYP_TBL

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: COUNTRY_TBL

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 ASOFDATE Date(10) DATE As of Date

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type Prompt Table: ADDRESS_TYP_TBL
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: COUNTRY_TBL
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	ASOFDATE	Date(10)	DATE	As of Date
23	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.