AV_REL_EP_MG_VW

(SQL View)
 Index Back

Org Match Add Match Relation

Organization matching gift, add matching gift Person to Organization relationships.

SELECT A.EXT_ORG_ID , A.EMPLID , A.NAME , B.LAST_NAME_SRCH , A.PE_RELATION , C.EP_REL_DESCR FROM PS_AV_RELATE_PE A , PS_SCC_PRI_NAME_VW B , PS_AV_PE_RLTN_TBL C WHERE A.EMPLID = B.EMPLID AND %EffdtCheck(SCC_PRI_NAME_VW B1,B,%CurrentDateIn) AND A.PE_RELATION = C.PE_RELATION AND %EffdtCheck(AV_PE_RLTN_TBL C1, C, %CurrentDateIn) AND ((BEGIN_DT <= %CurrentDateIn AND END_DT >= %CurrentDateIn) OR (BEGIN_DT <= %CurrentDateIn AND END_DT IS NULL) OR (BEGIN_DT IS NULL AND END_DT IS NULL) OR (BEGIN_DT IS NULL AND END_DT >= %CurrentDateIn))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

Prompt Table: EXT_ORG_TBL

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

Prompt Table: AV_PEOPLE_SRCH

3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
5 PE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship

Prompt Table: AV_PE_RLTN_TBL

6 EP_REL_DESCR Character(30) VARCHAR2(30) NOT NULL Org Description