FAST_SQR_SEC_VW(SQL View) |
Index Back |
---|---|
Core VW: SQR Security PPLJOBFast 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 |