PC_ANLTMPL_CAL(SQL Table) |
Index Back |
|---|---|
Analytics Template CalculationAnalytics Template Calculation |
| # | 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 | REP_CALC_ID |
Number(2,0) | SMALLINT NOT NULL | Reporting Calculation ID |
| 4 | REP_CALC_LBL | Character(30) | VARCHAR2(30) NOT NULL | Reporting Calculation Label |
| 5 | PARENTHESIS_1 | Character(1) | VARCHAR2(1) NOT NULL |
Paranthesis
(=Open Parenthesis )=Close Parenthesis |
| 6 | PARENTHESIS_2 | Character(1) | VARCHAR2(1) NOT NULL |
Paranthesis
(=Open Parenthesis )=Close Parenthesis |
| 7 | PARENTHESIS_3 | Character(1) | VARCHAR2(1) NOT NULL |
Paranthesis
(=Open Parenthesis )=Close Parenthesis |
| 8 | PARENTHESIS_4 | Character(1) | VARCHAR2(1) NOT NULL |
Paranthesis
(=Open Parenthesis )=Close Parenthesis |
| 9 | TRAN_GRP_CRIT_ID1 | Character(2) | VARCHAR2(2) NOT NULL |
Transaction Grouping Criteria ID
1=1 10=10 2=2 3=3 4=4 5=5 6=6 7=7 8=8 9=9 |
| 10 | TRAN_GRP_CRIT_ID2 | Character(2) | VARCHAR2(2) NOT NULL |
Transaction Grouping Criteria ID
1=1 10=10 2=2 3=3 4=4 5=5 6=6 7=7 8=8 9=9 |
| 11 | TRAN_GRP_CRIT_ID3 | Character(2) | VARCHAR2(2) NOT NULL |
Transaction Grouping Criteria ID
1=1 10=10 2=2 3=3 4=4 5=5 6=6 7=7 8=8 9=9 |
| 12 | OPERATOR_1 | Character(1) | VARCHAR2(1) NOT NULL |
Operator
*=Multiply +=Add -=Subtract /=Divide |
| 13 | OPERATOR_2 | Character(1) | VARCHAR2(1) NOT NULL |
Operator
*=Multiply +=Add -=Subtract /=Divide |