REPRESNT_ESPVW (SQL View)	Index Back
Company Representative Tbl ESP This table stores the Company Representatives in a Company.

REPRESNT_ESPVW

(SQL View)

Company Representative Tbl ESP

This table stores the Company Representatives in a Company.

SELECT A.COMPANY , A.REPRESNT_ID_ESP , A.EFFDT , A.REPRESNT_ROLE_ESP , A.EMPLID , B.NAME FROM PS_REPRESNTATV_ESP A , PS_NAMES B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 REPRESNT_ID_ESP Character(11) VARCHAR2(11) NOT NULL Company Representative ID

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 REPRESNT_ROLE_ESP Character(50) VARCHAR2(50) NOT NULL Representative Role

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

6 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	REPRESNT_ID_ESP	Character(11)	VARCHAR2(11) NOT NULL	Company Representative ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	REPRESNT_ROLE_ESP	Character(50)	VARCHAR2(50) NOT NULL	Representative Role
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: EMPL_CMP_VW_ESP
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name