JPM_JPXCPT_RCTL

(SQL Table)
Index Back

JPM Profile Header

Stores the profile ID and other header information for a profile.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 JPM_JP_GRP_TYPE Character(12) VARCHAR2(12) NOT NULL Group type to which a JPM profile group belongs

Prompt Table: JPM_JP_GTYPE

4 JPM_JP_GROUP Character(12) VARCHAR2(12) NOT NULL ID of the Profile Group to which a JPM profile belongs

Prompt Table: JPM_JP_GROUPS

5 EFFDT Date(10) DATE Effective Date

Default Value: %date