RE_LS_CONTACT

(SQL View)
Index Back

Lease Contacts


SELECT %subrec(RE_LS_CONTACT,A) FROM PS_RE_LS_CNTCT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
2 CNTCT_ID Number(10,0) DECIMAL(10) NOT NULL Contact ID
3 PARTY_KEY Number(10,0) DECIMAL(10) NOT NULL Party Key
4 PARTY_TYPE_CD Character(20) VARCHAR2(20) NOT NULL Party type code (Internal or External)
5 ROLE_TYP Character(1) VARCHAR2(1) NOT NULL Role Category
1=Principal Contact
2=External Contact
3=Internal Administrator
4=Internal Manager
5=Internal Clerk
6 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
7 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
8 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
9 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.