REL_JNT_ADDR_VW

(SQL View)
Index Back

Relation Joint Address View


SELECT EMPLID , ADDRESS_TYPE , EFFDT , EFF_STATUS , JOINT_ADDRESS_RCP FROM PS_RELATIONSHIPS WHERE JOINT_ADDRESS_RCP = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

Prompt Table: ADDRESS_TYP_TBL

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 JOINT_ADDRESS_RCP Character(1) VARCHAR2(1) NOT NULL Joint Address