SSR_REQS_RC_DRP

(SQL Table)
Index Back

PERC Drop Process

This record is the run control header record for the PERC drop process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

11 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_VAL_TBL

12 SSR_USE_CLASS_SEL Character(1) VARCHAR2(1) NOT NULL This field is used as a Y/N flag for deciding if classes can be manually entered for the class pop select.

Y/N Table Edit

Default Value: N

13 SSR_REQS_STAT_ENRL Character(1) VARCHAR2(1) NOT NULL Enrolled

Y/N Table Edit

Default Value: INSTALLATION_SR.SSR_REQS_STAT_ENRL

14 SSR_REQS_STAT_WAIT Character(1) VARCHAR2(1) NOT NULL Waitlisted

Y/N Table Edit

Default Value: INSTALLATION_SR.SSR_REQS_STAT_WAIT

15 SSR_REQS_BDRP_RVW Character(1) VARCHAR2(1) NOT NULL Process Drop for Review Comple

Y/N Table Edit

Default Value: INSTALLATION_SR.SSR_REQS_BDRP_RVW

16 SSR_REQS_BDRP_OPTN Character(1) VARCHAR2(1) NOT NULL Process drops for
C=Check Box
D=Drop Request
S=Status

Default Value: INSTALLATION_SR.SSR_REQS_BDRP_OPTN

17 SSR_REQS_BDRP_CON Character(1) VARCHAR2(1) NOT NULL Conditional

Y/N Table Edit

Default Value: INSTALLATION_SR.SSR_REQS_BDRP_CON

18 SSR_REQS_BDRP_NOTS Character(1) VARCHAR2(1) NOT NULL Not Satisfied

Y/N Table Edit

Default Value: INSTALLATION_SR.SSR_REQS_BDRP_NOTS

19 OVRD_ENRL_ACTN_DT Character(1) VARCHAR2(1) NOT NULL Override Action Date

Y/N Table Edit

Default Value: N

20 ENRL_ACTION_DT Date(10) DATE Enrollment Action Date
21 ENRL_ACTION_REASON Character(4) VARCHAR2(4) NOT NULL Enrollment Action Reason

Default Value: INSTALLATION_SR.ENRL_ACTION_REASON