HCR_SCRTY_INSTL

(SQL Table)
Index Back

HRCS Security Installation

Configuration options for Row Security Access

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HCR_INTL_SEC_FLG Character(1) VARCHAR2(1) NOT NULL Y/N field for whether International Security should be allowed. This type of security allows Users with access to a Host record to see the Home record, and/or for Users with access to a Home record can see the Host record(s).

Y/N Table Edit

Default Value: N

2 HCR_HOME_HOST_TYPE Character(1) VARCHAR2(1) NOT NULL Field to indicate whether International Security will be used. This field has the values of 'None', 'Both','Home can see Host','Host can see Home'.
1=Home can see Host
2=Host can see Home
3=Both
3 HCR_JPN_SEC_FLG Character(1) VARCHAR2(1) NOT NULL Use the Additional Appointment (Kenmu) Security? Only allowed if INSTALLATION.JPN = 'Y' and INSTALLATION.AA_ENABLED_JPN = 'Y'.

Y/N Table Edit

Default Value: N

4 HCR_ASGN_SEC_FLG Character(1) VARCHAR2(1) NOT NULL Use the Additional Assignments security. Allows the User to have access to the Additional Assignments when they have access to the Controlling Instance.

Y/N Table Edit

Default Value: N

5 HCR_ASGN_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type
1=Instance can see Assignment
2=Assignment can see Instance
3=Both
4=None

Default Value: 4