BUSINESS_UNITPrompt Table: OPR_DEF_TBL_PC
TEMPLATE_IDTRAN_GRP_CRIT_IDPrompt Table: PROJ_AN_GRP_TBL
Prompt Table: PROJ_RES_TYPE
Prompt Table: PROJ_CATG_TBL
Prompt Table: PROJ_SUBCAT_TBL
PC_ANLTMPL_CRT(SQL Table) |
Index Back |
|---|---|
Analytics Template CriteriaAnalytics Template Criteria Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: OPR_DEF_TBL_PC |
| 2 | TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 3 | TRAN_GRP_CRIT_ID |
Number(2,0) | SMALLINT NOT NULL | Transaction Grouping Criteria ID |
| 4 | TRAN_GRP_CRIT_LBL | Character(30) | VARCHAR2(30) NOT NULL | Transaction Grouping Criteria Label |
| 5 | ANALYSIS_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Analysis Group
Prompt Table: PROJ_AN_GRP_TBL |
| 6 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table: PROJ_RES_TYPE |
| 7 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table: PROJ_CATG_TBL |
| 8 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table: PROJ_SUBCAT_TBL |