SCC_LTRCD_SC_VW

(SQL View)
 Index Back

Letter Code Security View

LTRCD_SCRTY_VW is used as a prompt in the communication generation process. If the 'one emplid' option is not specified, this view will be used to show the user those Soft Copy letter codes which the Operator ID has access to through the 3C Group security.

SELECT DISTINCT G.Oprid , A.scc_letter_cd , A.Descr FROM PS_SCC_STN_LTR_TBL A , PS_COMM_CTXT_TBL B , PS_COMM_CTX_ME_TBL C , PS_COMM_CATG_TBL D , PS_COMM_CA_CTX_TBL E , PS_COMM_GRP_3C_TBL F , PS_OPR_GRP_3C_TBL G WHERE A.scc_letter_cd = C.scc_letter_cd AND B.Institution = C.Institution AND B.Comm_Context = C.Comm_Context AND B.Comm_Context = E.Comm_Context AND C.EffDT = B.EffDT AND B.EffDT = ( SELECT MAX(Z.EffDT) FROM PS_COMM_CTXT_TBL Z WHERE D.Institution = Z.Institution AND B.Comm_Context = Z.Comm_Context AND Z.EffDT <= D.EffDT) AND B.Eff_Status = 'A' AND B.Institution = D.Institution AND D.Institution = E.Institution AND D.EffDT = E.EffDT AND D.EffDT = ( SELECT MAX(Y.EffDT) FROM PS_COMM_CATG_TBL Y WHERE D.Institution = Y.Institution AND D.Comm_Category = Y.Comm_Category AND Y.EffDT <= %CurrentDateIn) AND D.Eff_Status = 'A' AND D.Comm_Category = E.Comm_Category AND F.Comm_Category = D.Comm_Category AND F.Institution = B.Institution AND F.Group_3C = G.Group_3C AND B.Institution = G.Institution AND G.Entry_Use_Ind = 'Y' AND A.SCC_CG_PARMS = 'Y'

  • Related Language Record: LTRCD_SCTYVW_LN

    • # 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 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description