PIN_NUMEFFDTF_SEQNUMGP_PKG_FM3_VW(SQL View) |
Index Back |
|---|---|
Packaging-Formula CluePackaging View for Global Payroll Formula Clue record. |
| SELECT PIN_NUM + 50000000 , EFFDT , F_SEQNUM , FRML_CLU0_ORD_NUM , FRML_CLU0_FLD1_TB , FRML_CLU0_FLD1_RW , PIN_RND1_FRML_CLU0 , FRML_CLU0_FLD2_TB , FRML_CLU0_FLD2_RW , PIN_RND2_FRML_CLU0 , FRML_CLU0_FLD3_TB , FRML_CLU0_FLD3_RW , FRML_CLU0_OPER , FRML_CLU0_BR , FRML_CLU1_ORD_NUM , FRML_CLU1_FLD1_TB , FRML_CLU1_FLD1_RW , PIN_RND1_FRML_CLU1 , FRML_CLU1_FLD2_TB , FRML_CLU1_FLD2_RW , PIN_RND2_FRML_CLU1 , FRML_CLU1_FLD3_TB , FRML_CLU1_FLD3_RW , FRML_CLU1_OPER , FRML_CLU1_BR , FRML_CLU2_ORD_NUM , FRML_CLU2_FLD1_TB , FRML_CLU2_FLD1_RW , PIN_RND1_FRML_CLU2 , FRML_CLU2_FLD2_TB , FRML_CLU2_FLD2_RW , PIN_RND2_FRML_CLU2 , FRML_CLU2_FLD3_TB , FRML_CLU2_FLD3_RW , FRML_CLU2_OPER , FRML_CLU2_BR , FRML_CLU3_ORD_NUM , FRML_CLU3_FLD1_TB , FRML_CLU3_FLD1_RW , PIN_RND1_FRML_CLU3 , FRML_CLU3_FLD2_TB , FRML_CLU3_FLD2_RW , PIN_RND2_FRML_CLU3 , FRML_CLU3_FLD3_TB , FRML_CLU3_FLD3_RW , FRML_CLU3_OPER , FRML_CLU3_BR , FRML_CLU4_ORD_NUM , FRML_CLU4_FLD1_TB , FRML_CLU4_FLD1_RW , PIN_RND1_FRML_CLU4 , FRML_CLU4_FLD2_TB , FRML_CLU4_FLD2_RW , PIN_RND2_FRML_CLU4 , FRML_CLU4_FLD3_TB , FRML_CLU4_FLD3_RW , FRML_CLU4_OPER , FRML_CLU4_BR , FRML_CLU5_ORD_NUM , FRML_CLU5_FLD1_TB , FRML_CLU5_FLD1_RW , PIN_RND1_FRML_CLU5 , FRML_CLU5_FLD2_TB , FRML_CLU5_FLD2_RW , PIN_RND2_FRML_CLU5 , FRML_CLU5_FLD3_TB , FRML_CLU5_FLD3_RW , FRML_CLU5_OPER , FRML_CLU5_BR FROM PS_GP_FORMULA_CLUE |
| # | 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 NOT NULL | Effective Date |
| 3 | F_SEQNUM |
Number(9,0) | DECIMAL(9) NOT NULL | Sequence number on Formula Instructions (CLUE) and Formula input (VAR) |
| 4 | FRML_CLU0_ORD_NUM | Number(9,0) | DECIMAL(9) NOT NULL | Formula clue field |
| 5 | FRML_CLU0_FLD1_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 6 | FRML_CLU0_FLD1_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 7 | PIN_RND1_FRML_CLU0 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 8 | FRML_CLU0_FLD2_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 9 | FRML_CLU0_FLD2_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 10 | PIN_RND2_FRML_CLU0 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 11 | FRML_CLU0_FLD3_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 12 | FRML_CLU0_FLD3_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 13 | FRML_CLU0_OPER | Number(3,0) | SMALLINT NOT NULL | Formula clue field |
| 14 | FRML_CLU0_BR | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 15 | FRML_CLU1_ORD_NUM | Number(9,0) | DECIMAL(9) NOT NULL | Formula clue field |
| 16 | FRML_CLU1_FLD1_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 17 | FRML_CLU1_FLD1_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 18 | PIN_RND1_FRML_CLU1 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 19 | FRML_CLU1_FLD2_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 20 | FRML_CLU1_FLD2_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 21 | PIN_RND2_FRML_CLU1 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 22 | FRML_CLU1_FLD3_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 23 | FRML_CLU1_FLD3_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 24 | FRML_CLU1_OPER | Number(3,0) | SMALLINT NOT NULL | Formula clue field |
| 25 | FRML_CLU1_BR | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 26 | FRML_CLU2_ORD_NUM | Number(9,0) | DECIMAL(9) NOT NULL | Formula clue field |
| 27 | FRML_CLU2_FLD1_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 28 | FRML_CLU2_FLD1_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 29 | PIN_RND1_FRML_CLU2 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 30 | FRML_CLU2_FLD2_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 31 | FRML_CLU2_FLD2_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 32 | PIN_RND2_FRML_CLU2 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 33 | FRML_CLU2_FLD3_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 34 | FRML_CLU2_FLD3_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 35 | FRML_CLU2_OPER | Number(3,0) | SMALLINT NOT NULL | Formula clue field |
| 36 | FRML_CLU2_BR | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 37 | FRML_CLU3_ORD_NUM | Number(9,0) | DECIMAL(9) NOT NULL | Formula clue field |
| 38 | FRML_CLU3_FLD1_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 39 | FRML_CLU3_FLD1_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 40 | PIN_RND1_FRML_CLU3 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 41 | FRML_CLU3_FLD2_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 42 | FRML_CLU3_FLD2_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 43 | PIN_RND2_FRML_CLU3 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 44 | FRML_CLU3_FLD3_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 45 | FRML_CLU3_FLD3_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 46 | FRML_CLU3_OPER | Number(3,0) | SMALLINT NOT NULL | Formula clue field |
| 47 | FRML_CLU3_BR | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 48 | FRML_CLU4_ORD_NUM | Number(9,0) | DECIMAL(9) NOT NULL | Formula clue field |
| 49 | FRML_CLU4_FLD1_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 50 | FRML_CLU4_FLD1_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 51 | PIN_RND1_FRML_CLU4 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 52 | FRML_CLU4_FLD2_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 53 | FRML_CLU4_FLD2_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 54 | PIN_RND2_FRML_CLU4 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 55 | FRML_CLU4_FLD3_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 56 | FRML_CLU4_FLD3_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 57 | FRML_CLU4_OPER | Number(3,0) | SMALLINT NOT NULL | Formula clue field |
| 58 | FRML_CLU4_BR | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 59 | FRML_CLU5_ORD_NUM | Number(9,0) | DECIMAL(9) NOT NULL | Formula clue field |
| 60 | FRML_CLU5_FLD1_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 61 | FRML_CLU5_FLD1_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 62 | PIN_RND1_FRML_CLU5 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 63 | FRML_CLU5_FLD2_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 64 | FRML_CLU5_FLD2_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 65 | PIN_RND2_FRML_CLU5 | Number(8,0) | INTEGER NOT NULL | Element number field associated with a Formula |
| 66 | FRML_CLU5_FLD3_TB | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 67 | FRML_CLU5_FLD3_RW | Number(8,0) | INTEGER NOT NULL | Formula clue field |
| 68 | FRML_CLU5_OPER | Number(3,0) | SMALLINT NOT NULL | Formula clue field |
| 69 | FRML_CLU5_BR | Number(8,0) | INTEGER NOT NULL | Formula clue field |