AVRELPEVWLNG (SQL View)	Index Back
Relationships Use RELATIONSHIPS to record information about a person's relationship to other person. You can enter multiple people. The GUARDIAN_RELATIONS field allow you to enter information about the legal relationship to this person, while the PEOPLE_RELATION field identifies the familial or other relationship to the person. For example, a grandparent may legally be a guardian and you would want to capture both these pieces of information about the relationship to the person. ======================================================== modified on 2/16/01 for hr merge impact, old sql is below. SELECT A.PE_RELATE_NBR , A.EXT_ORG_ID , A.EMPLID , A.PE_RELATION , B.XLATLONGNAME , A.DESCR , A.NAME , A.NAME_PREFIX , A.NAME_SUFFIX , A.SSN , A.SEX , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.NUM1 , A.NUM2 , A.HOUSE_TYPE , A.COUNTY , A.STATE , A.POSTAL , A.GEO_CODE , A.IN_CITY_LIMIT , A.BEGIN_DT , A.END_DT , A.SRC_DESCR , A.COMMENTS FROM PS_AV_RELATE_PE A , XLATTABLE B WHERE B.FIELDNAME='PE_RELATION' AND A.PE_RELATION=B.FIELDVALUE ========================================================

AVRELPEVWLNG

(SQL View)

Relationships

Use RELATIONSHIPS to record information about a person's relationship to other person. You can enter multiple people. The GUARDIAN_RELATIONS field allow you to enter information about the legal relationship to this person, while the PEOPLE_RELATION field identifies the familial or other relationship to the person. For example, a grandparent may legally be a guardian and you would want to capture both these pieces of information about the relationship to the person. ======================================================== modified on 2/16/01 for hr merge impact, old sql is below. SELECT A.PE_RELATE_NBR , A.EXT_ORG_ID , A.EMPLID , A.PE_RELATION , B.XLATLONGNAME , A.DESCR , A.NAME , A.NAME_PREFIX , A.NAME_SUFFIX , A.SSN , A.SEX , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.NUM1 , A.NUM2 , A.HOUSE_TYPE , A.COUNTY , A.STATE , A.POSTAL , A.GEO_CODE , A.IN_CITY_LIMIT , A.BEGIN_DT , A.END_DT , A.SRC_DESCR , A.COMMENTS FROM PS_AV_RELATE_PE A , XLATTABLE B WHERE B.FIELDNAME='PE_RELATION' AND A.PE_RELATION=B.FIELDVALUE ========================================================

SELECT A.PE_RELATE_NBR , A.EXT_ORG_ID , A.EMPLID , A.LANGUAGE_CD , A.DESCR , A.SRC_DESCR FROM PS_AVRELATEPELNG A ,PS_AV_RELATE_PE D , PSXLATITEM B WHERE B.FIELDNAME='PE_RELATION' AND D.PE_RELATION=B.FIELDVALUE AND A.PE_RELATE_NBR=D.PE_RELATE_NBR AND A.EXT_ORG_ID=D.EXT_ORG_ID AND A.EMPLID=D.EMPLID

Related Language Record for AV_REL_PE_VW

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PE_RELATE_NBR Character(10) VARCHAR2(10) NOT NULL Relation Nbr
Default Value: NEW

2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
Prompt Table: AV_EXT_ORG_SRCH

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: AV_PEOPLE_SRCH

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 SRC_DESCR Character(30) VARCHAR2(30) NOT NULL Source Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PE_RELATE_NBR	Character(10)	VARCHAR2(10) NOT NULL	Relation Nbr Default Value: NEW
2	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: AV_EXT_ORG_SRCH
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: AV_PEOPLE_SRCH
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	SRC_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Source Description