PIN_NUMEFFDTF_SEQNUMGP_PKG_FM4_VW(SQL View) |
Index Back |
|---|---|
Packaging - Formula VariablePackaging View for Global Payroll - Formula Variable record. |
| SELECT PIN_NUM + 50000000 , EFFDT , F_SEQNUM , FRML_VAR1_TB , FRML_VAR1_RW , PIN_FRML_VAR1 , FRML_VAR1_TYPE , FRML_VAR1_USE_OPTN , FRML_VAR1_PTR_IND , FRML_VAR1_OLDV_IND , FRML_VAR1_DEC_VAL , FRML_VAR1_DTE_VAL , FRML_VAR1_CHR_VAL , FRML_VAR2_TB , FRML_VAR2_RW , PIN_FRML_VAR2 , FRML_VAR2_TYPE , FRML_VAR2_USE_OPTN , FRML_VAR2_PTR_IND , FRML_VAR2_OLDV_IND , FRML_VAR2_DEC_VAL , FRML_VAR2_DTE_VAL , FRML_VAR2_CHR_VAL , FRML_VAR3_TB , FRML_VAR3_RW , PIN_FRML_VAR3 , FRML_VAR3_TYPE , FRML_VAR3_USE_OPTN , FRML_VAR3_PTR_IND , FRML_VAR3_OLDV_IND , FRML_VAR3_DEC_VAL , FRML_VAR3_DTE_VAL , FRML_VAR3_CHR_VAL , FRML_VAR4_TB , FRML_VAR4_RW , PIN_FRML_VAR4 , FRML_VAR4_TYPE , FRML_VAR4_USE_OPTN , FRML_VAR4_PTR_IND , FRML_VAR4_OLDV_IND , FRML_VAR4_DEC_VAL , FRML_VAR4_DTE_VAL , FRML_VAR4_CHR_VAL , FRML_VAR5_TB , FRML_VAR5_RW , PIN_FRML_VAR5 , FRML_VAR5_TYPE , FRML_VAR5_USE_OPTN , FRML_VAR5_PTR_IND , FRML_VAR5_OLDV_IND , FRML_VAR5_DEC_VAL , FRML_VAR5_DTE_VAL , FRML_VAR5_CHR_VAL FROM PS_GP_FORMULA_VAR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | F_SEQNUM |
Number(9,0) | DECIMAL(9) NOT NULL | Sequence number on Formula Instructions (CLUE) and Formula input (VAR) |
| 4 | FRML_VAR1_TB | Number(8,0) | INTEGER NOT NULL | Formula variable field |
| 5 | FRML_VAR1_RW | Number(8,0) | INTEGER NOT NULL | Formula variable field |
| 6 | PIN_FRML_VAR1 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 7 | FRML_VAR1_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 8 | FRML_VAR1_USE_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 9 | FRML_VAR1_PTR_IND | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 10 | FRML_VAR1_OLDV_IND | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 11 | FRML_VAR1_DEC_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Formula variable field |
| 12 | FRML_VAR1_DTE_VAL | Date(10) | DATE | Formula variable field |
| 13 | FRML_VAR1_CHR_VAL | Character(18) | VARCHAR2(18) NOT NULL | Formula variable field |
| 14 | FRML_VAR2_TB | Number(8,0) | INTEGER NOT NULL | Formula variable field |
| 15 | FRML_VAR2_RW | Number(8,0) | INTEGER NOT NULL | Formula variable field |
| 16 | PIN_FRML_VAR2 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 17 | FRML_VAR2_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 18 | FRML_VAR2_USE_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 19 | FRML_VAR2_PTR_IND | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 20 | FRML_VAR2_OLDV_IND | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 21 | FRML_VAR2_DEC_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Formula variable field |
| 22 | FRML_VAR2_DTE_VAL | Date(10) | DATE | Formula variable field |
| 23 | FRML_VAR2_CHR_VAL | Character(18) | VARCHAR2(18) NOT NULL | Formula variable field |
| 24 | FRML_VAR3_TB | Number(8,0) | INTEGER NOT NULL | Formula variable field |
| 25 | FRML_VAR3_RW | Number(8,0) | INTEGER NOT NULL | Formula variable field |
| 26 | PIN_FRML_VAR3 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 27 | FRML_VAR3_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 28 | FRML_VAR3_USE_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 29 | FRML_VAR3_PTR_IND | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 30 | FRML_VAR3_OLDV_IND | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 31 | FRML_VAR3_DEC_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Formula variable field |
| 32 | FRML_VAR3_DTE_VAL | Date(10) | DATE | Formula variable field |
| 33 | FRML_VAR3_CHR_VAL | Character(18) | VARCHAR2(18) NOT NULL | Formula variable field |
| 34 | FRML_VAR4_TB | Number(8,0) | INTEGER NOT NULL | Formula variable field |
| 35 | FRML_VAR4_RW | Number(8,0) | INTEGER NOT NULL | Formula variable field |
| 36 | PIN_FRML_VAR4 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 37 | FRML_VAR4_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 38 | FRML_VAR4_USE_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 39 | FRML_VAR4_PTR_IND | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 40 | FRML_VAR4_OLDV_IND | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 41 | FRML_VAR4_DEC_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Formula variable field |
| 42 | FRML_VAR4_DTE_VAL | Date(10) | DATE | Formula variable field |
| 43 | FRML_VAR4_CHR_VAL | Character(18) | VARCHAR2(18) NOT NULL | Formula variable field |
| 44 | FRML_VAR5_TB | Number(8,0) | INTEGER NOT NULL | Formula variable field |
| 45 | FRML_VAR5_RW | Number(8,0) | INTEGER NOT NULL | Formula variable field |
| 46 | PIN_FRML_VAR5 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 47 | FRML_VAR5_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 48 | FRML_VAR5_USE_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 49 | FRML_VAR5_PTR_IND | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 50 | FRML_VAR5_OLDV_IND | Character(1) | VARCHAR2(1) NOT NULL | Formula variable field |
| 51 | FRML_VAR5_DEC_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Formula variable field |
| 52 | FRML_VAR5_DTE_VAL | Date(10) | DATE | Formula variable field |
| 53 | FRML_VAR5_CHR_VAL | Character(18) | VARCHAR2(18) NOT NULL | Formula variable field |