PROCESS_INSTANCEEMPLIDCAL_RUN_IDEMPL_RCDGP_PAYGROUPCAL_IDPIN_NUMUSER_KEY1USER_KEY2USER_KEY3USER_KEY4USER_KEY5USER_KEY6RSLT_SEG_NUMPrompt Table: STATE_TBL
GPTH_50BIS_TMP(SQL Table) |
Index Back |
|---|---|
Personal Report TempPersonal Report Temp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 6 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 7 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 8 | USER_KEY1 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 1 |
| 9 | USER_KEY2 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 2 |
| 10 | USER_KEY3 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 3 |
| 11 | USER_KEY4 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 4 |
| 12 | USER_KEY5 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 5 |
| 13 | USER_KEY6 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 6 |
| 14 | RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 15 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL | Name Prefix |
| 16 | GPTH_NAME1 | Character(80) | VARCHAR2(80) NOT NULL | Tax-Payee's First Name |
| 17 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 18 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 19 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 20 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 21 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 22 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 23 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 24 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 25 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 26 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 27 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 28 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 29 | GPTH_COMP_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 30 | GPTH_COMP_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 31 | GPTH_COMP_ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 32 | GPTH_COMP_ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 33 | GPTH_COMP_CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 34 | GPTH_COMP_COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 35 | GPTH_COMP_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country for Company |
| 36 | GPTH_COMP_STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 37 | GPTH_COMP_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 38 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 39 | GPTH_PER_TAX_ID | Character(20) | VARCHAR2(20) NOT NULL | Person Tax ID |
| 40 | PYMT_DT | Date(10) | DATE | Payment Date |
| 41 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 42 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 43 | ACM_FROM_DT | Date(10) | DATE | From Date |
| 44 | ACM_THRU_DT | Date(10) | DATE | Through Date |
| 45 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 46 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 47 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 48 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 49 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 50 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 51 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 52 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 53 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 54 | GPTH_GOV | Character(1) | VARCHAR2(1) NOT NULL | This field represents that if the report is an Government report |
| 55 | GPTH_SEQ_NUM | Character(6) | VARCHAR2(6) NOT NULL | Sequence number for tax report |
| 56 | GPTH_TAX_ID | Character(10) | VARCHAR2(10) NOT NULL | Tax identification number |
| 57 | GPTH_TAX_BRANCH | Character(6) | VARCHAR2(6) NOT NULL | Tax branch number |
| 58 | GPTH_TAX_ID_L | Character(13) | VARCHAR2(13) NOT NULL | Tax identification number 13 |
| 59 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 60 | PIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Element Type |
| 61 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 62 | PIN_CODE | Character(22) | VARCHAR2(22) NOT NULL | Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN) |
| 63 | PIN_CUSTOM1 | Character(20) | VARCHAR2(20) NOT NULL | Customer FIelds |
| 64 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 65 | SEQ_NUM8 | Number(8,0) | INTEGER NOT NULL | Sequence Number |