GPBR_CAT_RP_AET

(SQL Table)
Index Back

Run Control CAT Form BRA

Run Control CAT Form BRA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPERATOR_VW

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: GPBR_CMP_FLG_VW

5 DATE_FROM Date(10) DATE Date From
6 DATE_TO Date(10) DATE Previous Period Date To
7 GPBR_CAT_TYP2 Character(2) VARCHAR2(2) NOT NULL CAT Type Form
01=Initial
02=Reopened
03=Death Communication
04=All

Default Value: 04

8 GPBR_SEARCH_CAT Character(2) VARCHAR2(2) NOT NULL Search By CAT
01=Employee
02=Establishment
03=Incident

Default Value: 01

9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
10 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
11 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).
12 GPBR_TIME_PRD_CAT Character(2) VARCHAR2(2) NOT NULL Period Time CAT Form
01=Last 30 days
02=Last 60 days
03=Last 90 days
04=Custom Period

Default Value: 01

13 DTTM_WORKED_FROM DateTime(26) TIMESTAMP Worked Datetime From
14 DTTM_WORKED_TO DateTime(26) TIMESTAMP Worked Datetime To
15 BIND_VALUE Character(254) VARCHAR2(254) NOT NULL Bind Value
16 BIND_VALUE1 Character(50) VARCHAR2(50) NOT NULL Bind Value
17 BIND_VALUE2 Character(50) VARCHAR2(50) NOT NULL Bind Value