RUN_CNTL_NM_DIS

(SQL Table)
Index Back

HR Run Control for Security

Contains fields that are used as input parameters for the Security Join Table updates to SJT_CLASS_ALL

# 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 UPDATE_ALL_NM Character(1) VARCHAR2(1) NOT NULL Update All Name Formats?

Y/N Table Edit

Default Value: Y

4 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types

Prompt Table: NAME_FORMAT_TBL

5 NM_UPD_NAMES Character(1) VARCHAR2(1) NOT NULL Update NAMES record

Y/N Table Edit

Default Value: Y

6 NM_UPD_DEP Character(1) VARCHAR2(1) NOT NULL Update Dependents

Y/N Table Edit

Default Value: N

7 NM_UPD_FPS Character(1) VARCHAR2(1) NOT NULL Update French Public Sector

Y/N Table Edit

Default Value: N

8 NM_UPD_HRS Character(1) VARCHAR2(1) NOT NULL Update Applicants

Y/N Table Edit

Default Value: N

9 NM_UPD_HS Character(1) VARCHAR2(1) NOT NULL Update HS Non-Employees

Y/N Table Edit

Default Value: N

10 NM_UPD_USF Character(1) VARCHAR2(1) NOT NULL Update US Federal Names

Y/N Table Edit

Default Value: N