GPBR_CAT_RP_AET(SQL Table) |
Index Back |
|---|---|
Run Control CAT Form BRARun Control CAT Form BRA |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
|
| 3 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 4 | 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 |