SSR_APT_SYN_RUN

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: PRCSRUNCNTL.OPRID

2 RUN_CNTL_ID 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