RE_INTPARTY (SQL View)	Index Back
Party Types View This record is used for the setup and configuration of the Internal party Types (Internal-Administrator, Internal-manager). These two Party Types are created by default for each Business Unit and cannot be deleted by the user.

RE_INTPARTY

(SQL View)

Party Types View

This record is used for the setup and configuration of the Internal party Types (Internal-Administrator, Internal-manager). These two Party Types are created by default for each Business Unit and cannot be deleted by the user.

SELECT A.SETID ,A.PARTY_TYPE_CD ,A.INSTANCE_NAME FROM PS_RE_PTY_TYPE A WHERE A.ROLE_TYP IN ('3', '4','5') AND %CurrentDateIn BETWEEN A.EFFDT AND A.END_EFFDT AND A.EFF_STATUS = 'A'

Related Language Record: RE_INTPARTY_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	PARTY_TYPE_CD	Character(20)	VARCHAR2(20) NOT NULL	Party type code (Internal or External)
3	INSTANCE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Role Type Name