SCC_LTRCD_P2_VW

(SQL View)
 Index Back

Letter Code Person 2 View

LTRCD_PERS2_VW is used as a prompt in the communication generation process. If the 'All Person IDs' option was specified, this view will be used to show the user those Soft Copy letter codes for person type communications.

SELECT DISTINCT D.Oprid , B.scc_Letter_CD , A.Descr FROM PS_SCC_STN_LTR_TBL A , PS_COMMUNICATION B , PS_COMM_GRP_3C_TBL C , PS_OPR_GRP_3C_TBL D WHERE B.Completed_Comm <> 'Y' AND A.scc_Letter_Cd = B.scc_Letter_Cd AND B.Institution = C.Institution AND C.Institution = D.Institution AND B.Comm_Category = C.Comm_Category AND C.Group_3c = D.Group_3c AND D.Entry_Use_Ind = 'Y' AND B.Sa_Id_Type = 'P' AND A.SCC_CG_PARMS = 'Y'

  • Related Language Record: LTRCD_PER2VW_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