SSR_APT_SYN_RUN(SQL Table) | 
Index Back | 
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | 
A user's ID (see PSOPRDEFN).
 Default Value: PRCSRUNCNTL.OPRID  | 
|
| 2 | Character(30) | VARCHAR2(30) NOT NULL | 
Run Control ID
 Default Value: PRCSRUNCNTL.RUN_CNTL_ID  | 
|
| 3 | 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  | 
| 4 | 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  | 
| 5 | SCCPS_QUERY_NAME | Character(50) | VARCHAR2(50) NOT NULL | 
Query / Section name used by population selection
 Prompt Table: %EDITTABLE  | 
| 6 | 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  | 
| 7 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename | 
| 8 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File | 
| 9 | SCCPS_FILE_PATH | Character(254) | VARCHAR2(254) NOT NULL | Pop Select File Path and Name | 
| 10 | SSR_APT_SYN_CREATE | Character(1) | VARCHAR2(1) NOT NULL | 
Create APT Items
 Y/N Table Edit Default Value: Y  | 
| 11 | SSR_APT_SYN_DELETE | Character(1) | VARCHAR2(1) NOT NULL | 
Delete APT Course
 D=Set to Dropped Status E=As Defined in Enrol Category R=Set to Planned status Default Value: E  | 
| 12 | SSR_APT_SYN_CRSEEQ | Character(1) | VARCHAR2(1) NOT NULL | 
Use Course Equivalency
 Y/N Table Edit Default Value: Y  | 
| 13 | SSR_APTSYNC_REQSRC | Character(2) | VARCHAR2(2) NOT NULL | 
APT Sync Request Source
 SM=APT Sync - Manual Entry SP=APT Sync - Pop Select  | 
| 14 | SSR_APT_SYN_REMOVE | Character(1) | VARCHAR2(1) NOT NULL | 
Remove APT Sync Gen Sub
 Y/N Table Edit Default Value: Y  | 
| 15 | SSR_APT_SYN_REMOPT | Character(1) | VARCHAR2(1) NOT NULL | 
Remove APT Sync Gen Sub Option
 A=Always O=Only on DD and Deleted TC Default Value: A  | 
| 16 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |