SSR_IAM_STBLK

(SQL Table)
Index Back

Activity Block Selections

Activity Block Selections Header for Students

  • Related Language Record: SSR_IAM_STBLKLN
  • Parent Record Of SSR_IAM_STBLKID
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 SSR_IAM_STD_BLK_ID Character(20) VARCHAR2(20) NOT NULL Student Block ID
    3 SSR_IAM_BLK_EXMFLG Character(1) VARCHAR2(1) NOT NULL Display Exam Activities Only

    Y/N Table Edit

    Default Value: N

    4 SSR_DESCR80 Character(80) VARCHAR2(80) NOT NULL This field is used for holding the 80 character description used in the xml file for post enrollment requisite check reports.
    5 SCCPS_POP_SEL Character(1) VARCHAR2(1) NOT NULL Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.

    Y/N Table Edit

    Default Value: Y

    6 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool

    Prompt Table: SCCPS_TOOL_VW

    7 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection

    Prompt Table: %EDITTABLE

    8 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context

    Prompt Table: SCCPS_CNTXT_VW

    9 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    10 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    11 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
    12 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    13 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    14 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    15 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time