SCC_CG_RUN_LBLS(SQL Table) |
Index Back |
---|---|
Label/Envelope Gen Run ControlLabel/Envelope Generation run control contains fields that are used as input parameters for generating labels and/or envelopes. |
# | 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 | SCC_CG_COMM_PI | Number(10,0) | DECIMAL(10) NOT NULL |
Communication Process Instance (processed comms).
Prompt Table: SCC_CG_COMPRCVW |
4 | CG_COMM_ID_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Communication ID Select Option
A=All IDs E=All Person IDs O=One Org ID P=Population Selection R=All Org IDs S=One Person ID Default Value: A |
5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: %EDITTABLE2 |
6 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: %EDITTABLE3 |
7 | 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 |
8 | 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 |
9 | SCCPS_QUERY_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Query / Section name used by population selection
Prompt Table: %EDITTABLE |
10 | 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 |
11 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
12 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
13 | SCCPS_FILE_PATH | Character(254) | VARCHAR2(254) NOT NULL | Pop Select File Path and Name |
14 | SCC_LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL |
Letter Code
Prompt Table: SCC_LTRCD_VW |
15 | FROM_DT | Date(10) | DATE |
From Date
Default Value: %date |
16 | TO_DT | Date(10) | DATE |
To Date
Default Value: %date |
17 | ADDR_NAME_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Address Name
Prompt Table: NAME_USAGE_VW |
18 | ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table: ADDR_USAGE_TBL |
19 | CNTC_NAME_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Contact Name
Prompt Table: NAME_USAGE_VW |
20 | EXTRACT_NAME_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
ID Extract Name Usage
Prompt Table: NAME_USAGE_VW |
21 | JOINT_NAME_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Joint Name Usage
Prompt Table: J_NAME_USAGE_VW |
22 | ORG_RCP_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Organization Recipient Usage
Prompt Table: SCC_ORG_USAGE |
23 | SALUT_NAME_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Salutation Name
Prompt Table: NAME_USAGE_VW |
24 | COMPLETED_DT | Date(10) | DATE | Date Activity Completed |
25 | DATE_COMPLETED_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Date Activity Completed Option
C=Communication Date D=User Supplied Date S=System Date Default Value: S |
26 | DATE_PRINTED_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Date Letter Printed Option
C=Communication Date D=User Supplied Date S=System Date Default Value: S |
27 | LETTER_PRINTED_DT | Date(10) | DATE | Date letter was printed |
28 | COMPLETE_COMM | Character(1) | VARCHAR2(1) NOT NULL |
Complete Communication
Y/N Table Edit Default Value: Y |
29 | COMPLETE_COMM_MCD | Character(1) | VARCHAR2(1) NOT NULL |
Complete Communication
Y/N Table Edit Default Value: Y |
30 | PRODUCE_COMM | Character(1) | VARCHAR2(1) NOT NULL |
Produce Communication
Y/N Table Edit Default Value: Y |
31 | CG_SORT_OPTION_LTR | Character(1) | VARCHAR2(1) NOT NULL |
Sort Option for Comm Gen
1=Country, Postal 2=Country, Postal by ID Type 3=All Alphabetically by ID Type Default Value: 1 |
32 | FILE_PATH | Character(127) | VARCHAR2(127) NOT NULL | Input/Output file path |
33 | PRINT_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Send to Printer
Y/N Table Edit Default Value: N |
34 | DESTPRINTER | Character(127) | VARCHAR2(127) NOT NULL | Destination Printer |
35 | SCC_CG_CREATE_ENV | Character(1) | VARCHAR2(1) NOT NULL |
Comm Gen Generate Envlopes option.
Y/N Table Edit Default Value: N |
36 | SCC_CG_CREATE_LBLS | Character(1) | VARCHAR2(1) NOT NULL |
Comm Gen Generate Labels option.
Y/N Table Edit Default Value: N |
37 | SCC_CG_ENV_PRINTER | Character(127) | VARCHAR2(127) NOT NULL | Printer Name for Comm Gen Envelopes. |
38 | SCC_CG_ENV_RPTNM | Character(12) | VARCHAR2(12) NOT NULL | Report Definition ID for Comm Gen Envelopes. |
39 | SCC_CG_LBL_PRINTER | Character(127) | VARCHAR2(127) NOT NULL | Printer name for Comm Gen Labels. |
40 | SCC_CG_LBL_RPTNM | Character(12) | VARCHAR2(12) NOT NULL | Report Definition ID for Comm Gen Labels. |
41 | SCC_CG_FILE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
CommGen Send to File Output Option
Y/N Table Edit Default Value: N |
42 | SCC_CG_PREVIEW | Character(1) | VARCHAR2(1) NOT NULL |
Online Preview
Y/N Table Edit |