SCC_LTRCD_P_VW

(SQL View)
 Index Back

Letter Code Person View

LTRCD_PERSON_VW is used as a prompt in the communication generation process. If the 'One Person ID' option was specified, this view will be used to show the user those Soft Copy letter codes which the ID has in the communication.

SELECT DISTINCT D.Oprid , B.Common_Id , 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_PERSVW_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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description