FUNCTN_NAMEFUNCTN_SEQ_NUMFLD_SEQ_NUMPA_FUNCTN_FLD_1(SQL Table) |
Index Back |
|---|---|
Fields for FunctionsThis is a setup table containing the names of the fields which will be output of the calculation. These are mostly the intermediate values used for each function. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FUNCTN_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Function Name |
| 2 | FUNCTN_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Function Sequence Number |
| 3 | FLD_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Field Sequence Number |
| 4 | FLD_NAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 5 | FLD_PICTURE | Character(10) | VARCHAR2(10) NOT NULL | Picture Format |
| 6 | FLD_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Field Type |
| 7 | FLD_CODE | Character(1) | VARCHAR2(1) NOT NULL | Field Code |