SCRTY_SETTYP_VW

(SQL View)
 Index Back

Security Set / Type View

View of Security Types by Security Set

SELECT B.SCRTY_SET_CD ,A.SCRTY_TYPE_CD ,A.DESCR ,B.RECNAME_SJT ,A.RECNAME_S_TRANS ,A.KEY1_PROMPT_FLD ,A.KEY2_PROMPT_FLD ,A.KEY3_PROMPT_FLD ,A.ENABLED , A.FUTURE_FLG , A.HCR_HOME_HOST_TYPE , A.HCR_JPN_SEC_FLG , A.HCR_ASGN_TYPE FROM PS_SCRTY_TYPE_TBL A , PS_SCRTY_SET_TBL B WHERE A.SCRTY_SET_CD = B.SCRTY_SET_CD AND A.ENABLED = 'Y'

  • Related Language Record: SCRTY_SETTYP_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCRTY_SET_CD Character(10) VARCHAR2(10) NOT NULL Security Set

    Prompt Table: SCRTY_SET_TBL

    2 SCRTY_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Security Type for RowLevelSecurty

    Prompt Table: SCRTY_TYPE_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 RECNAME_SJT Character(15) VARCHAR2(15) NOT NULL Name of the Security Join Table for the Transaction side of this Security Access Type. "What is being secured". This is not a required field as not all "whats" will need a SJT table.

    Prompt Table: PSRECDEFN_VW1

    5 RECNAME_S_TRANS Character(15) VARCHAR2(15) NOT NULL Transaction Data Record Name used for a Security Access Type

    Prompt Table: PSRECDEFN_VW1

    6 KEY1_PROMPT_FLD Character(18) VARCHAR2(18) NOT NULL Scrty_type_tbl prompt field for security Key 1

    Prompt Table: SCRTY_FLD_VW

    7 KEY2_PROMPT_FLD Character(18) VARCHAR2(18) NOT NULL Scrty_type_tbl prompt field for security Key 1

    Prompt Table: SCRTY_FLD_VW2

    8 KEY3_PROMPT_FLD Character(18) VARCHAR2(18) NOT NULL Scrty_type_tbl prompt field for security Key 1

    Prompt Table: SCRTY_FLD_VW3

    9 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.

    Y/N Table Edit

    Default Value: Y

    10 FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Flag for the SJT_*** record that indicates whether this is a future dated row or not. Y = Future N = Current

    Y/N Table Edit

    Default Value: N

    11 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
    12 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

    13 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