SSR_RS_CDAT_STG

(SQL Table)
Index Back

RET Candidate Attachments

Candidate Attachments record for Research Enrollment Tracking.

  • Parent record: SSR_RS_CNDH_STG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number
    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
    13 SSR_RS_VIEW_STD_SS Character(1) VARCHAR2(1) NOT NULL Visible to Student

    Y/N Table Edit

    Default Value: N