SCC_TM_BAT_AET (SQL Table)	Index Back
State Record for Assign Tasks State Record for Assign Tasks process

SCC_TM_BAT_AET

(SQL Table)

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_START_DATE Date(10) DATE Start Date

6 SCC_TM_DUE_DATE Date(10) DATE Due Date

7 SCC_TM_PROC_MODE Character(1) VARCHAR2(1) NOT NULL Assign Tasks Prcoessing Mode
A=Assign Tasks
R=Review Assignment

8 SCC_TM_STDNT_OVRD Character(1) VARCHAR2(1) NOT NULL Student Override

9 SCC_TM_STDGRP_IND Character(1) VARCHAR2(1) NOT NULL Student Group

10 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

11 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group

12 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

13 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

14 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

15 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection
Prompt Table: %EDITTABLE

16 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

17 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

18 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

19 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name

20 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.

#	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_START_DATE	Date(10)	DATE	Start Date
6	SCC_TM_DUE_DATE	Date(10)	DATE	Due Date
7	SCC_TM_PROC_MODE	Character(1)	VARCHAR2(1) NOT NULL	Assign Tasks Prcoessing Mode A=Assign Tasks R=Review Assignment
8	SCC_TM_STDNT_OVRD	Character(1)	VARCHAR2(1) NOT NULL	Student Override
9	SCC_TM_STDGRP_IND	Character(1)	VARCHAR2(1) NOT NULL	Student Group
10	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
11	STDNT_GROUP	Character(4)	VARCHAR2(4) NOT NULL	Student Group
12	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
13	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
14	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
15	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection Prompt Table: %EDITTABLE
16	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
17	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
18	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
19	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name
20	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.