FAST_SQR_SEC_VW

(SQL View)
Index Back

Core VW: SQR Security PPLJOB

Fast security view to be used in the SQRs. Only one row per EMPLID / EMPL_RCD is selected and no Future dated rows are selected.

SELECT %Sql(SCRTY_SEL_PKEY, OPR,SEC) , SEC.APPT_TYPE , SEC.HCR_JPN_SEC_FLG , SEC.HCR_ASGN_TYPE , SEC.HCR_HOME_HOST_TYPE FROM %Sql(SCRTY_PER_FROM) WHERE %Sql(SCRTY_NO_APPT1) AND SEC.FUTURE_FLG <> 'Y' AND SEC.HCR_JPN_SEC_FLG <> 'Y' AND %Sql(SCRTY_WHERE, 'PPLJOB')

# 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 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
5 APPT_TYPE Character(1) VARCHAR2(1) NOT NULL This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers.
0=Core Appointment
1=Japan Kenmu Appointment
2=French Public Sector Appt
3=Staffing
6 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

7 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
8 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