LTRCD_ORG_VW

(SQL View)
 Index Back

Letter Code Org View

LTRCD_ORG_VW is used as a prompt in the letter generation process. If the 'One Org ID' option was specified, this view will be used to show the user those 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 = 'O'

  • Related Language Record: LTRCD_ORG_VW_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 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    3 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description