SCC_CG_RUN_LBLS

(SQL Table)
Index Back

Label/Envelope Gen Run Control

Label/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