SCC_TM_BAT1_AET

(SQL Table)
Index Back

State Record for Assign Tasks

State Record for Assign Tasks process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 SCC_TM_TASK_ID Character(31) VARCHAR2(31) NOT NULL Template ID

Prompt Table: PTAI_LIST

5 SCC_TM_LIST_ID Character(31) VARCHAR2(31) NOT NULL Template ID
6 SCC_TM_EX_STATUS Character(2) VARCHAR2(2) NOT NULL Existing Status
AL=All
CA=Cancelled
CP=Completed
IP=In Progress

Default Value: IP

7 SCC_TM_NEW_STATUS Character(2) VARCHAR2(2) NOT NULL New Status
CA=Cancelled
CP=Completed
IP=In Progress
8 SCC_TM_DUE_DATE Date(10) DATE Due Date
9 SCC_TM_STDNT_OVRD Character(1) VARCHAR2(1) NOT NULL Student Override
10 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
11 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
12 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

13 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

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

Prompt Table: %EDITTABLE

15 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

16 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
17 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
18 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
19 SCCPS_RSLTS_TABLE Character(15) VARCHAR2(15) NOT NULL Results table for population selection. This is the table that is populated with the results of the selection. This table is set on the Context.
20 SCC_TM_TOTAL_CNT Number(15,0) DECIMAL(15) NOT NULL Total