MILESTONE_SVW

(SQL View)
 Index Back

Milestone Table View

This view is used to display milestones based on user access.

SELECT A.OPRID , A.INSTITUTION , B.MILESTONE , B.EFFDT , B.EFF_STATUS , B.DESCR FROM %Table(SCRTY_TBL_MLSTN) A , %Table(MILESTONE_TBL) B WHERE A.INSTITUTION = B.INSTITUTION AND A.ENTRY_USE_IND = 'Y' AND (A.MILESTONE = 'ALL' OR (A.MILESTONE = B.MILESTONE AND NOT EXISTS ( SELECT 'X' FROM %Table(SCRTY_TBL_MLSTN) A1 WHERE A1.OPRID = A.OPRID AND A1.INSTITUTION = A.INSTITUTION AND A1.MILESTONE = 'ALL' AND A1.ENTRY_USE_IND = 'Y')))

  • Related Language Record: MILESTONE_SVWLN

    • # 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 MILESTONE Character(10) VARCHAR2(10) NOT NULL Milestone
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description