TD_FORMULA_IDC=Checkbook Review Formula
F=Fund Budget Formula
Default Value: C
A=Absolute Value
N=None
R=Round
T=Truncate
Default Value: N
N=Display As Number
U=Display As Units
Y=Display As Currency
Default Value: N
TD_FORMULA(SQL Table) |
Index Back |
|---|---|
Formula Information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TD_FORMULA_ID |
Character(10) | VARCHAR2(10) NOT NULL | Formula ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | TD_FORMULA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Formula Type
C=Checkbook Review Formula F=Fund Budget Formula Default Value: C |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | TD_MATH_FUNC | Character(1) | VARCHAR2(1) NOT NULL |
Result Modifier
A=Absolute Value N=None R=Round T=Truncate Default Value: N |
| 6 | TD_DISPLAY_AS_CURR | Character(1) | VARCHAR2(1) NOT NULL |
Display As Currency
N=Display As Number U=Display As Units Y=Display As Currency Default Value: N |
| 7 | TD_PREFACE_STRING | Character(3) | VARCHAR2(3) NOT NULL | Preface String |
| 8 | TD_SUFFIX_STRING | Character(3) | VARCHAR2(3) NOT NULL | Suffix String |
| 9 | TD_PRECISION | Number(1,0) | SMALLINT NOT NULL | Decimal Positions |
| 10 | COMMENTS | Long Character | CLOB | Comment |