RUNCNT_USERPROF

(SQL Table)
Index Back

Run Cntl for User Profile Prcs

This record is used in the Run Control page for User Profile Batch Process.

# 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 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: OPER_ROLE_DEFN

4 CREATE_USERPROF Character(1) VARCHAR2(1) NOT NULL Create User Profiles

Y/N Table Edit

Default Value: N

5 DELETE_USERPROF Character(1) VARCHAR2(1) NOT NULL Delete Role in User Profiles

Y/N Table Edit

Default Value: N

6 ASSIGN_SETUP_VAL Character(1) VARCHAR2(1) NOT NULL Assign Default Values

Y/N Table Edit

Default Value: N

7 ASSIGN_ROLE Character(1) VARCHAR2(1) NOT NULL Assign Roles

Y/N Table Edit

8 LINK_EXPL_UP_PRO1 Character(1) VARCHAR2(1) NOT NULL Link Explanation UserProfile 1
9 LINK_EXPL_UP_PR02 Character(1) VARCHAR2(1) NOT NULL
10 LINK_EXPL_UP_PR03 Character(1) VARCHAR2(1) NOT NULL
11 LINK_EXPL_UP_PR04 Character(1) VARCHAR2(1) NOT NULL
12 LINK_EXPL_UP_PR05 Character(1) VARCHAR2(1) NOT NULL Explain
13 SCC_UPDATE_PTSAML Character(1) VARCHAR2(1) NOT NULL Create SAML definition indicator

Y/N Table Edit

Default Value: N

14 CERTALIAS Character(50) VARCHAR2(50) NOT NULL Certificate Alias

Prompt Table: PSCERTALIAS_VW
Set Control Field: CERTALIAS

15 PTISSUER Character(30) VARCHAR2(30) NOT NULL Issuer for Security Assertion MarkUp Language (SAML]
16 PTQUALIFIERNAME Character(30) VARCHAR2(30) NOT NULL Domain Name of the SubjectName for Security Assertion MarkUp Language (SAML]
17 SCC_ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Set to Active
A=Active
I=Inactive

Default Value: A

18 COMMENTS Long Character CLOB Comment