ORG_CNTC_ASOF (SQL View)	Index Back
Organization Contact Table USE ORG_CONTACT to maintain information about a contact's address within an organization. The address information is maintained in the organization location table and gets associated to a contact by setting either the department number or the location number in this table.

ORG_CNTC_ASOF

(SQL View)

Organization Contact Table

USE ORG_CONTACT to maintain information about a contact's address within an organization. The address information is maintained in the organization location table and gets associated to a contact by setting either the department number or the location number in this table.

SELECT A.EXT_ORG_ID , A.ORG_CONTACT , A.EFFDT , A.EFF_STATUS , A.EMPLID , A.CONTACT_NAME , A.ORG_LOCATION , A.ORG_DEPARTMENT , A.ORG_CONTACT_TYPE , A.JOBTITLE FROM PS_ORG_CONTACT A WHERE %EffdtCheck(ORG_CONTACT A1, A, %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 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr

3 AS_OF_DATE Date(10) DATE As of Date

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

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

6 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name

7 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr
Prompt Table: ORG_LOCATION

8 ORG_DEPARTMENT Number(3,0) SMALLINT NOT NULL Department Nbr
Prompt Table: ORG_DEPT

9 ORG_CONTACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contact Type
Prompt Table: ORG_CNT_TYP_TBL

10 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title

#	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	ORG_CONTACT	Number(4,0)	SMALLINT NOT NULL	Contact Nbr
3	AS_OF_DATE	Date(10)	DATE	As of Date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
6	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name
7	ORG_LOCATION	Number(3,0)	SMALLINT NOT NULL	Location Nbr Prompt Table: ORG_LOCATION
8	ORG_DEPARTMENT	Number(3,0)	SMALLINT NOT NULL	Department Nbr Prompt Table: ORG_DEPT
9	ORG_CONTACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contact Type Prompt Table: ORG_CNT_TYP_TBL
10	JOBTITLE	Character(30)	VARCHAR2(30) NOT NULL	Job Title