SCC_GE_SCHATTVW

(SQL View)
 Index Back

EMS Scheme Attachments View

Evaluation Management System Scheme Attachments View Used by Self Service pages to show Committee Scheme and Individual Evaluator Scheme Attachments together under single scroll area.

SELECT A.SCC_GE_INSTANCE_ID , '2' , A.SCC_GE_COMM_SCHEME , A.ATTACH_SEQ_NBR , A.DESCR254 , A.SCC_DATE , A.SCC_ROW_ADD_OPRID , A.SCC_ROW_ADD_DTTM , A.SCC_ROW_UPD_OPRID , A.SCC_ROW_UPD_DTTM , A.ATTACHSYSFILENAME , A.ATTACHUSERFILE FROM PS_SCC_GE_CM_SCATT A UNION ALL SELECT B.SCC_GE_INSTANCE_ID , '3' , B.SCC_GE_IE_SCHEME , B.ATTACH_SEQ_NBR , B.DESCR254 , B.SCC_DATE , B.SCC_ROW_ADD_OPRID , B.SCC_ROW_ADD_DTTM , B.SCC_ROW_UPD_OPRID , B.SCC_ROW_UPD_DTTM , B.ATTACHSYSFILENAME , B.ATTACHUSERFILE FROM PS_SCC_GE_IE_SCATT B

  • Parent record: SCC_GE_SCHORDVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_GE_INSTANCE_ID Number(16,0) DECIMAL(16) NOT NULL Evaluation Instance
    2 SCC_GE_SCHEME_TYPE Character(1) VARCHAR2(1) NOT NULL Scheme Type
    1=Auto-Calculated
    2=Committee
    3=Individual Evaluator
    3 SCC_GE_SCHEME_NAME Character(10) VARCHAR2(10) NOT NULL Scheme Name
    4 ATTACH_SEQ_NBR Number(3,0) SMALLINT NOT NULL Attachment Sequence Number
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 SCC_DATE Date(10) DATE NOT NULL The date the file was created
    7 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    8 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    9 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    10 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    11 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    12 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File