SCC_POP_UPD_VW

(SQL View)
 Index Back

Pop Update secured rec view

This is a search/prompt view to select Records for Population Update with based on security access.

SELECT B.OPRID ,A.RECNAME , A.RECNAME %Concat ' - ' %Concat A.DESCR50 FROM PS_SCC_POP_UPD_REC A , PS_SCCPU_SRTY_TBL B WHERE A.RECNAME=B.RECNAME

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRDEFN2

    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description