RE_PTY_TYPE (SQL Table)	Index Back
Interested Party Setup This record is used in setup and configuration of the Interested party Types (Principal, External, Internal-Administrator and Internal-Manager) for Lease Administration. The Internal Parties are defined at the Business Unit Level.

RE_PTY_TYPE

(SQL Table)

Interested Party Setup

This record is used in setup and configuration of the Interested party Types (Principal, External, Internal-Administrator and Internal-Manager) for Lease Administration. The Internal Parties are defined at the Business Unit Level.

Related Language Record: RE_PTYTYPE_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 PARTY_TYPE_CD Character(20) VARCHAR2(20) NOT NULL Party type code (Internal or External)

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

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

5 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Role Type Name

6 END_EFFDT Date(10) DATE Ending effective date established to be used by queries to improve effective-date processing performance.

7 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
Default Value: 1

8 INSTANCE_DESCR Character(150) VARCHAR2(150) NOT NULL Generic Description Field for Instances of Generic Entities

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	PARTY_TYPE_CD	Character(20)	VARCHAR2(20) NOT NULL	Party type code (Internal or External)
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	INSTANCE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Role Type Name
6	END_EFFDT	Date(10)	DATE	Ending effective date established to be used by queries to improve effective-date processing performance.
7	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 Default Value: 1
8	INSTANCE_DESCR	Character(150)	VARCHAR2(150) NOT NULL	Generic Description Field for Instances of Generic Entities