RUN_CNTL_CBR

(SQL Table)
 Index Back

COBRA Run Control

Controls COBRA Letters and Reports. (Note: SYSTEM_DATE field is used for testing only).

# 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 ASOFDATE Date(10) DATE As of Date
4 REPRINT_PROMPT Character(1) VARCHAR2(1) NOT NULL Reprint

Y/N Table Edit

Default Value: N

5 PRINT_ID Character(6) VARCHAR2(6) NOT NULL Print ID

Prompt Table: CBR_PRNT

6 FROMDATE Date(10) DATE From Date
7 THRUDATE Date(10) DATE End Date
8 CBR_SORT_PARM1 Character(1) VARCHAR2(1) NOT NULL Sort Parameter 1
1=EmplId
2=Event Date/EmplId
3=Event/Event Date/EmplId
4=Qualified Status/EmplId
5=Employee Name
6=Event Date/Employee Name
7=Event/Event Date/Employee Name
8=Qualified Status/Employee Name

Default Value: 1

9 CBR_SORT_PARM2 Character(1) VARCHAR2(1) NOT NULL Sort Parameter 2
1=EmplId
2=Plan Type/EmplId
3=Employee Name
4=Plan Type/Employee Name

Default Value: 1

10 PRINT_OPTION Character(1) VARCHAR2(1) NOT NULL Send to Printer

Y/N Table Edit

Default Value: N

11 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date
12 PERIOD_END_DT Date(10) DATE Period End Date
13 SYSTEM_DATE Date(10) DATE System Date

Default Value: %Date