BO_PRSN_PCNTCT

(SQL View)
Index Back

Person Primary Representative

This is the Person Primary Representative view.

SELECT A.PERSON_ID , B.BO_ID_CONTACT , B.ROLE_TYPE_ID_CNTCT , B.START_DT , B.END_DT , B.BO_REL_ID FROM PS_RD_PERSON A , PS_BO_ROLE_PCNTCT B WHERE A.BO_ID = B.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
3 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
4 START_DT Date(10) DATE Start date field to store start date value.
5 END_DT Date(10) DATE This field stores the end date values.
6 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object