GPTH_ITF_TMP(SQL Table) |
Index Back |
|---|---|
Personal Report TempPersonal Report Temp COUNTRY -- Country of Address COUNTRY2 -- Country of Citizenship |
| # | 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 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 30 | GPTH_PER_TAX_ID | Character(20) | VARCHAR2(20) NOT NULL | Person Tax ID |
| 31 | PYMT_DT | Date(10) | DATE | Payment Date |
| 32 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 33 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 34 | ACM_FROM_DT | Date(10) | DATE | From Date |
| 35 | ACM_THRU_DT | Date(10) | DATE | Through Date |
| 36 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 37 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 38 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 39 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 40 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 41 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 42 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 43 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 44 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 45 | GPTH_GOV | Character(1) | VARCHAR2(1) NOT NULL | This field represents that if the report is an Government report |
| 46 | GPTH_SEQ_NUM | Character(6) | VARCHAR2(6) NOT NULL | Sequence number for tax report |
| 47 | GPTH_TAX_ID | Character(10) | VARCHAR2(10) NOT NULL | Tax identification number |
| 48 | GPTH_TAX_BRANCH | Character(6) | VARCHAR2(6) NOT NULL | Tax branch number |
| 49 | GPTH_TAX_ID_L | Character(13) | VARCHAR2(13) NOT NULL | Tax identification number 13 |
| 50 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 51 | PIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Element Type |
| 52 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 53 | 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) |
| 54 | PIN_CUSTOM1 | Character(20) | VARCHAR2(20) NOT NULL | Customer FIelds |
| 55 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 56 | SEQ_NUM8 | Number(8,0) | INTEGER NOT NULL | Sequence Number |
| 57 | GPTH_SEQ_NUM_INODR | Character(1) | VARCHAR2(1) NOT NULL |
Income type order field. WH-1 / GA-2 / GO-3
Default Value: 0 |
| 58 | GPTH_SENDER_ID | Character(4) | VARCHAR2(4) NOT NULL | Sender Id |
| 59 | GPTH_SENDER_NID | Character(13) | VARCHAR2(13) NOT NULL | Sender Identification Id |
| 60 | GPTH_SENDER_BRANCH | Character(6) | VARCHAR2(6) NOT NULL | Sender Branch No |
| 61 | GPTH_SENDER_ROLE | Character(1) | VARCHAR2(1) NOT NULL |
Sender Role
1=Withholding tax Payer 2=Representative 3=Agent 4=Flling Joinly |
| 62 | GPTH_LTO | Character(1) | VARCHAR2(1) NOT NULL |
Large Business Tax Administration Office
0=None LTO 1=LTO |
| 63 | GPTH_BRANCH_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Tax Branch Type
B=VAT&SBT S=Special Business Tax Branch V=Value Added Tax Branch |
| 64 | GPTH_USER_ID | Character(20) | VARCHAR2(20) NOT NULL | User Id |
| 65 | GPTH_DEP_NAME | Character(80) | VARCHAR2(80) NOT NULL | Department Name |