GPGB_P45_AET(SQL Table) |
Index Back |
|---|---|
GP UK P45 State RecordState record used with the GPGB_P45 application engine program |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 5 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 6 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 7 | ORIG_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 8 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 9 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 10 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
| 11 | RSLT_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Result Revision Number |
| 12 | GPGB_ER_TAXNUM | Number(3,0) | SMALLINT NOT NULL | Employer's Tax Number |
| 13 | GPGB_ER_PAYE_REF | Character(10) | VARCHAR2(10) NOT NULL | Employer's PAE reference number |
| 14 | GPGB_ER_TAX_DNAME | Character(40) | VARCHAR2(40) NOT NULL | Employer's Tax District Name |
| 15 | GPGB_TAX_BGN_YR | Number(4,0) | SMALLINT NOT NULL | Tax Year Begins In This Calendar Year |
| 16 | GPGB_TAX_PERIOD | Number(3,0) | SMALLINT NOT NULL | Tax Period |
| 17 | GPGB_ER_NAME | Character(36) | VARCHAR2(36) NOT NULL | Employer's name |
| 18 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: SCC_CNT_ADFMTVW |
| 19 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 20 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 21 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 22 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 23 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 24 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 25 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 26 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 27 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 28 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 29 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 30 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 31 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 32 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 33 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 34 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 35 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 36 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 37 | GPGB_JOB_EFFDT | Date(10) | DATE | GP UK Job Effective Date |
| 38 | COUNTRY_NM_FORMAT | Character(3) | VARCHAR2(3) NOT NULL |
Supported Name Format Types
Prompt Table: NAME_FORMAT_TBL |
| 39 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 40 | NAME_INITIALS | Character(6) | VARCHAR2(6) NOT NULL | Name Initials |
| 41 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table: NAME_PREFIX_TBL |
| 42 | NAME_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL |
Name Suffix
Prompt Table: NAME_SUFFIX_TBL |
| 43 | NAME_ROYAL_PREFIX | Character(15) | VARCHAR2(15) NOT NULL |
Name Royal Prefix
Prompt Table: NM_ROYPREF_GBL |
| 44 | NAME_ROYAL_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL |
Name Royal Suffix
Prompt Table: NM_ROYSUFF_GBL |
| 45 | NAME_TITLE | Character(30) | VARCHAR2(30) NOT NULL |
Title
Prompt Table: TITLE_TBL |
| 46 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 47 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 48 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 49 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 50 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 51 | SECOND_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 52 | SECOND_LAST_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Second Name |
| 53 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 54 | PREF_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Preferred First Name |
| 55 | PARTNER_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name. |
| 56 | PARTNER_ROY_PREFIX | Character(15) | VARCHAR2(15) NOT NULL |
The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.
Prompt Table: NM_ROYPREF_GBL |
| 57 | LAST_NAME_PREF_NLD | Character(1) | VARCHAR2(1) NOT NULL |
The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
1=Own Name 2=Name Partner 3=Name Partner + Own Name 4=Own Name + Name Partner Default Value: 1 |
| 58 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 59 | NAME_FORMAL | Character(60) | VARCHAR2(60) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 60 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 61 | TAX_CODE_UK | Character(15) | VARCHAR2(15) NOT NULL | Tax Code for UK |
| 62 | PYMT_DT | Date(10) | DATE | Payment Date |
| 63 | TAX_BASIS_UK | Character(1) | VARCHAR2(1) NOT NULL |
Tax Basis
0=Cumulative 1=Week 1/Month 1 |
| 64 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 65 | HIRE_DT | Date(10) | DATE | First Start Date |
| 66 | LEAVE_DT | Date(10) | DATE | Leave Date |
| 67 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 68 | USER_KEY1 | Character(25) | VARCHAR2(25) NOT NULL | User Key 1 |
| 69 | FREQUENCY_ID | Character(5) | VARCHAR2(5) NOT NULL | Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency. |
| 70 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 71 | USER_ADJ_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | User Adjustment Value |
| 72 | CHR_PIN_VAL | Character(30) | VARCHAR2(30) NOT NULL | Calculation Character Result |
| 73 | DATE_PIN_VAL | Date(10) | DATE | Calculation Date Result |
| 74 | PIN_VAL_NUM | Number(8,0) | INTEGER NOT NULL | Calculation Element Number Result |
| 75 | GPGB_EE_SL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Student loans |
| 76 | EMPLID_FROM | Character(11) | VARCHAR2(11) NOT NULL | EMPLID (first for a range) |
| 77 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL | EmplID To |
| 78 | GPGB_P45_PRC_OGN | Character(3) | VARCHAR2(3) NOT NULL |
P45 Process Origin
IDE=P45 Identification REP=P45 Report RES=P45 Identification Results |
| 79 | GPGB_FROM_DT | Date(10) | DATE | GP UK From Date |
| 80 | GPGB_TO_DT | Date(10) | DATE | GP UK To Date |
| 81 | GPGB_P45_PRINTED | Character(1) | VARCHAR2(1) NOT NULL | P45 - Draft or Final print |
| 82 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 83 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 84 | GPGB_P45_GEN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Determines action when processing P45 process.
D=Delete P45 Production O=Calendar Override P=Produce P45 S=Suspend P45 Production U=Unprocess/Unfinal Term Cal ID |
| 85 | GPGB_COUNT | Number(19,0) | DECIMAL(19) NOT NULL | GP UK Counter |
| 86 | GPGB_FILE_NAME | Character(250) | VARCHAR2(250) NOT NULL | File Name for EFT |
| 87 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 88 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 89 | RUN_FINALIZED_IND | Character(1) | VARCHAR2(1) NOT NULL | Finalized Run |
| 90 | START_DT | Date(10) | DATE | Start Date |
| 91 | END_DT | Date(10) | DATE | end date |
| 92 | EFFDT | Date(10) | DATE | Effective Date |
| 93 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 94 | ADDRESS1_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 1 Other |
| 95 | ADDRESS2_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 2 Other |
| 96 | ADDRESS3_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 3 Other |
| 97 | ADDRESS4_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 4 Other |
| 98 | CITY_OTHER | Character(30) | VARCHAR2(30) NOT NULL | City Other |
| 99 | STATE_OTHER | Character(6) | VARCHAR2(6) NOT NULL | State Other |
| 100 | POSTAL_OTHER | Character(12) | VARCHAR2(12) NOT NULL | Postal Other |
| 101 | COUNTRY_OTHER | Character(3) | VARCHAR2(3) NOT NULL | Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT |
| 102 | COUNTRY_DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Country Description |
| 103 | COUNTRY_DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Country Description |
| 104 | GPGB_EE_TAX | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total tax |
| 105 | GPGB_EE_GROSS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total gross |
| 106 | GPGB_EE_P45_PAY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | P45 Total Pay To Date |
| 107 | GPGB_EE_P45_TAX | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | P45 Total Tax To Date |
| 108 | GPGB_P45_STLOAN | Character(1) | VARCHAR2(1) NOT NULL | Continue Student Loan Deductions from P45. |
| 109 | DT_OF_DEATH | Date(10) | DATE | Date of Death |
| 110 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 111 | GPGB_OPEN_FILE | Character(1) | VARCHAR2(1) NOT NULL | Open File |
| 112 | GPGB_P45_EFFDT | Date(10) | DATE | Field used to store P45 Effdt according to Job and Process Action Reason definition. |
| 113 | SRC_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Run ID |
| 114 | GPGB_FILE_PATH | Character(250) | VARCHAR2(250) NOT NULL | Output File Path |
| 115 | ACM_FROM_DT | Date(10) | DATE | From Date |