RE_INT_PARTY

(SQL Table)
 Index Back

Internal Party Types

This record holds all the users belonging to the Role Category of "Internal Administrator" and "Internal Manger"

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PARTY_KEY Number(10,0) DECIMAL(10) NOT NULL Party Key
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: %EDITTABLE

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RE_NONVW

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

Prompt Table: RE_INTPARTY

5 APPROVE_FLG Character(1) VARCHAR2(1) NOT NULL Can Approve Lease

Y/N Table Edit

Default Value: N

6 CAN_APPROVE_TXN Character(1) VARCHAR2(1) NOT NULL Approve Transaction Flag

Y/N Table Edit

7 CAN_CREATE_TXN Character(1) VARCHAR2(1) NOT NULL Create Transaction Flag

Y/N Table Edit

8 CAN_CREATE_LEASE Character(1) VARCHAR2(1) NOT NULL Create Lease Flag

Y/N Table Edit

Default Value: Y

9 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive