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