FO_TLASG_ACT_SV

(SQL View)
 Index Back

Activity team view for T&L

Activity team language view for use in Time and Labor product

SELECT O.CLASSID , X.EMPLID , X.BUSINESS_UNIT_PC , X.PROJECT_ID , X.ACTIVITY_ID , X.EMPL_RCD , X.START_DT , X.END_DT , P.DESCR FROM PS_PERSON E , PS_PROJ_ACTIVITY P , PSCLASSDEFN O , PS_FO_EMPL_XREF X WHERE P.EFF_STATUS = 'A' AND X.BUSINESS_UNIT_PC = P.BUSINESS_UNIT AND X.PROJECT_ID = P.PROJECT_ID AND X.ACTIVITY_ID = P.ACTIVITY_ID AND X.EMPLID = E.EMPLID AND ( P.ENFORCE IN ('N','E') OR EXISTS ( SELECT 'X' FROM PS_PC_ACT_TEAM_VW TEAM WHERE P.BUSINESS_UNIT = TEAM.BUSINESS_UNIT AND P.PROJECT_ID = TEAM.PROJECT_ID AND P.ACTIVITY_ID = TEAM.ACTIVITY_ID AND E.EMPLID = TEAM.TEAM_MEMBER ) ) AND ( (EXISTS ( SELECT 'X' FROM PS_TL_GRP_SECURITY S WHERE S.ROWSECCLASS = O.CLASSID) AND X.EMPLID IN ( SELECT F.EMPLID FROM PS_TL_GRP_SECURITY S , PS_TL_GROUP_DTL F WHERE S.TL_GROUP_ID = F.TL_GROUP_ID AND F.EMPLID = X.EMPLID AND F.EMPL_RCD = X.EMPL_RCD AND S.ROWSECCLASS = O.CLASSID )) OR (NOT EXISTS ( SELECT 'X' FROM PS_TL_GRP_SECURITY S WHERE S.ROWSECCLASS = O.CLASSID ) AND X.EMPLID IN ( SELECT PS.EMPLID FROM PS_PERS_SRCH_GBL PS WHERE X.EMPLID = PS.EMPLID AND X.EMPL_RCD = PS.EMPL_RCD AND PS.ROWSECCLASS = O.CLASSID) ) )

  • Related Language Record: FO_ACTEAM_TLLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL Project Costing Business Unit
    4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
    5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    7 START_DT Date(10) DATE Start Date
    8 END_DT Date(10) DATE end date
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description