RUN_CNTL_PORTAL

(SQL Table)
Index Back

Portal Run Control

RUN_CNTL_PORTAL contains fields that are used as input parameters for the portal analysis processes.

# 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 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name

Default Value: REGISTRY.TXT

4 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

Default Value: EMPLOYEE

Prompt Table: PSPRDMDEFN

5 PORTAL_CNTPRV_NAM Character(30) VARCHAR2(30) NOT NULL Content Provider Name

Prompt Table: HC_CNTPRV_VW

6 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name

Prompt Table: HC_PRTLOBJ_VW

7 HC_PORTAL_FLAG Character(1) VARCHAR2(1) NOT NULL Process Result
1=Portal Navigation Hardcopy
2=Portal/Menu Path
8 DISPLAY_LEVELS Number(2,0) SMALLINT NOT NULL Display Levels
9 HC_PORTAL_SHOWOBJ Character(1) VARCHAR2(1) NOT NULL Show Object Names

Y/N Table Edit

10 HC_PORTAL_NOHIDDEN Character(1) VARCHAR2(1) NOT NULL Suppress Hidden Objects

Y/N Table Edit

11 HC_PORTAL_SHOWMENU Character(1) VARCHAR2(1) NOT NULL Show Menu.Component.Market

Y/N Table Edit

12 HC_SECURITY_FLAG Character(1) VARCHAR2(1) NOT NULL Apply Security Based On
P=Permission List
R=Role
U=UserId

Default Value: U

13 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: PSOPRDEFN

14 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: PSROLEDEFN

15 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

Prompt Table: PSCLASSDEFN