GPGB_REPLIB_AET(SQL Table) |
Index Back |
|---|---|
GP UK report library state recState record used with the GPGB_REPLIB application engine library. |
| # | 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 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 8 | COUNTER_GLOB | Number(19,3) | DECIMAL(18,3) NOT NULL | Counter |
| 9 | START_DT | Date(10) | DATE | Start Date |
| 10 | END_DT | Date(10) | DATE | end date |
| 11 | ACM_FROM_DT | Date(10) | DATE | From Date |
| 12 | AE_TEST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Test Flag |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 14 | DESCR10 | Character(10) | VARCHAR2(10) NOT NULL | Description field of length 10 |
| 15 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 16 | GPGB_EOYR_FILENAME | Character(6) | VARCHAR2(6) NOT NULL | End of year submissions filename |
| 17 | GPGB_EOYR_SUBTYPE | Character(1) | VARCHAR2(1) NOT NULL |
End of Year Submissions - Submission method
C=Data Cartridge D=Flexible Diskette R=CD ROM T=Magnetic Tape |
| 18 | GPGB_EOYR_SUBTOT | Character(1) | VARCHAR2(1) NOT NULL |
End of Year Submissions - Subtotal by Paygroup option flag.
N=No Y=Yes |
| 19 | GPGB_ER_PERMIT_NUM | Character(12) | VARCHAR2(12) NOT NULL | Permit Number for end of year submissions on magnetic media. |
| 20 | GPGB_ER_TAXNUM | Number(3,0) | SMALLINT NOT NULL | Employer's Tax Number |
| 21 | GPGB_ER_PAYE_REF | Character(10) | VARCHAR2(10) NOT NULL | Employer's PAE reference number |
| 22 | GPGB_ER_TAX_DNAME | Character(40) | VARCHAR2(40) NOT NULL | Employer's Tax District Name |
| 23 | GPGB_TAX_BGN_YR | Number(4,0) | SMALLINT NOT NULL | Tax Year Begins In This Calendar Year |
| 24 | GPGB_ER_NAME | Character(36) | VARCHAR2(36) NOT NULL | Employer's name |
| 25 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: SCC_CNT_ADFMTVW |
| 26 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 27 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 28 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 29 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 30 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 31 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 32 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 33 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 34 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 35 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 36 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 37 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 38 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 39 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 40 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 41 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 42 | GPGB_ECON | Character(9) | VARCHAR2(9) NOT NULL | Employers Contracted Out Number |
| 43 | GPGB_REQ_ECON | Character(9) | VARCHAR2(9) NOT NULL | Employers Contracted Out Number |
| 44 | GPGB_NO_ECON | Character(1) | VARCHAR2(1) NOT NULL | Field used to include ees without ECON numbers in eoyr submissions |
| 45 | GPGB_PROC_EE | Character(1) | VARCHAR2(1) NOT NULL | Flag to determine if EE should be included in EOYR submission |
| 46 | GPGB_SCON | Character(9) | VARCHAR2(9) NOT NULL | SCON - Scheme Contracted Out Number |
| 47 | GPGB_NI_CATEGORY | Character(2) | VARCHAR2(2) NOT NULL |
NI Category Code
A=Standard Not C/Out A1=IOM - CATEGORY A AA=Standard Not C/Out in APP AA=Standard Not C/Out in APP B=Reduced Not C/Out BA=Reduced Not C/Out in APP BA=Reduced Not C/Out in APP C=Retirement Age Exemption CA=Co Deferrment in APPS CO=C/Out Deferment in COSR Scheme D=Standard C/Out Salary Related D1=IOM - CATEGORY D E=Reduced C/Out Salary Related F=Standard C/Out Money Purchase F=Standard C/Out Money Purchase G=Reduced C/Out Money Purchase G=Reduced C/Out Money Purchase J=Deferment Not C/Out L=Deferment C/Out Salary Related N=Contracted-OSR-standard rate O=Contracted-OUS-reduced rate Q=Deferment R=Standard Rate S=Deferment C/Out Money Purchase S=Deferment C/Out Money Purchase T=Reduced Rate W=Over State Pension Age X=Other Exemption |
| 48 | GPGB_SV_TAX_IND | Character(1) | VARCHAR2(1) NOT NULL | Scottish Variable Tax Indicator - Y/N. If this is set to Y then the Tax Code entered should be prefixed with an 'S' |
| 49 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 50 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 51 | COUNTRY_NM_FORMAT | Character(3) | VARCHAR2(3) NOT NULL |
Supported Name Format Types
Prompt Table: NAME_FORMAT_TBL |
| 52 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 53 | NAME_INITIALS | Character(6) | VARCHAR2(6) NOT NULL | Name Initials |
| 54 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table: NAME_PREFIX_TBL |
| 55 | NAME_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL |
Name Suffix
Prompt Table: NAME_SUFFIX_TBL |
| 56 | NAME_ROYAL_PREFIX | Character(15) | VARCHAR2(15) NOT NULL |
Name Royal Prefix
Prompt Table: NM_ROYPREF_GBL |
| 57 | NAME_ROYAL_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL |
Name Royal Suffix
Prompt Table: NM_ROYSUFF_GBL |
| 58 | NAME_TITLE | Character(30) | VARCHAR2(30) NOT NULL |
Title
Prompt Table: TITLE_TBL |
| 59 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 60 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 61 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 62 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 63 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 64 | SECOND_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 65 | SECOND_LAST_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Second Name |
| 66 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 67 | PREF_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Preferred First Name |
| 68 | 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. |
| 69 | 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 |
| 70 | 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 |
| 71 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 72 | NAME_FORMAL | Character(60) | VARCHAR2(60) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 73 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 74 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 75 | TAX_CODE_UK | Character(15) | VARCHAR2(15) NOT NULL | Tax Code for UK |
| 76 | PYMT_DT | Date(10) | DATE | Payment Date |
| 77 | TAX_BASIS_UK | Character(1) | VARCHAR2(1) NOT NULL |
Tax Basis
0=Cumulative 1=Week 1/Month 1 |
| 78 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 79 | HIRE_DT | Date(10) | DATE | First Start Date |
| 80 | LEAVE_DT | Date(10) | DATE | Leave Date |
| 81 | USER_KEY1 | Character(25) | VARCHAR2(25) NOT NULL | User Key 1 |
| 82 | 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. |
| 83 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 84 | USER_ADJ_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | User Adjustment Value |
| 85 | CHR_PIN_VAL | Character(30) | VARCHAR2(30) NOT NULL | Calculation Character Result |
| 86 | DATE_PIN_VAL | Date(10) | DATE | Calculation Date Result |
| 87 | PIN_VAL_NUM | Number(8,0) | INTEGER NOT NULL | Calculation Element Number Result |
| 88 | GPGB_DIRECTOR_IND | Character(1) | VARCHAR2(1) NOT NULL | Indicates if Employee is a Director |
| 89 | GPGB_TOT_ER_EE_NIC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's and Employee's national insurance contributions |
| 90 | GPGB_TOT_TAX | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total tax for permit number. |
| 91 | GPGB_EOYR_NUMRECS | Number(7,0) | INTEGER NOT NULL | End of Year Submissions - Number of records in permit number. |
| 92 | GPGB_TOT_SSP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total SSP in permit number. |
| 93 | GPGB_TOT_NIC_HOLS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total NIC Holiday claimed in this permit number. |
| 94 | GPGB_TOT_SMP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total SMP in this permit number. |
| 95 | GPGB_TOT_NIC_COMP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total NIC compensation on SMP in this permit number. |
| 96 | GPGB_TOT_SPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total SPPA in this permit number. |
| 97 | GPGB_TOT_COMPSPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total NIC compensation on SPPA in this permit number. |
| 98 | GPGB_TOT_SPPB | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total SPPB in this permit number. |
| 99 | GPGB_TOT_COMPSPPB | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total NIC compensation on SPPB in this permit number. |
| 100 | GPGB_TOT_SAP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total SAP in this permit number. |
| 101 | GPGB_TOT_COMP_SAP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total NIC compensation on SAP in this permit number. |
| 102 | GPGB_TOT_EE_ER_RBT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employee/Employer NIC rebate in permit number. |
| 103 | GPGB_TOT_SL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total student loan deductions in permit number. |
| 104 | GPGB_TOT_TC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total tax credits in permit number. |
| 105 | GPGB_NI_CAT_1 | Character(2) | VARCHAR2(2) NOT NULL | End of Year Submissions - NI category code. |
| 106 | GPGB_LEL_1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings at LEL |
| 107 | GPGB_LEL_ET_1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above LEL up to ET |
| 108 | GPGB_ET_UEL_1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above ET up to UEL |
| 109 | GPGB_ER_NIC_1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's contributions |
| 110 | GPGB_ER_RBT_1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's rebate |
| 111 | GPGB_EE_NIC_1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Employee NIC |
| 112 | GPGB_EE_RBT_1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employee's rebate |
| 113 | GPGB_SCON_1 | Character(9) | VARCHAR2(9) NOT NULL | End of Year Submissions - SCON - Scheme Contracted Out Number |
| 114 | GPGB_EE_NIC_RBT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Employee NIC rebate |
| 115 | GPGB_ER_NIC_RBT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Employer NIC rebate |
| 116 | GPGB_SSP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SSP |
| 117 | GPGB_SMP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SMP |
| 118 | GPGB_SPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SPPA |
| 119 | GPGB_SPPB | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SPPB |
| 120 | GPGB_NIC_COMP_SPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - NIC compensation on SPPA in this permit number |
| 121 | GPGB_NIC_COMP_SPPB | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - NIC compensation on SPPB in this permit number |
| 122 | GPGB_SAP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SAP |
| 123 | GPGB_NIC_COMP_SAP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - NIC compensation on SAP in this permit number |
| 124 | GPGB_NIC_HOLS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - NIC Holiday claimed in this permit number |
| 125 | GPGB_EE_GROSS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total gross |
| 126 | GPGB_EE_TAX | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total tax |
| 127 | GPGB_P45_PAY_TD | Number(13,2) | DECIMAL(12,2) NOT NULL | Total Pay to Date from P45 |
| 128 | GPGB_P45_TAX_TD | Number(13,2) | DECIMAL(12,2) NOT NULL | Total Tax to Date from P45 |
| 129 | GPGB_EE_SL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Student loans |
| 130 | GPGB_EE_TC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Tax credits |
| 131 | GPGB_WK53_IND | Character(2) | VARCHAR2(2) NOT NULL | GP UK - Week 53 indicator |
| 132 | GPGB_NI_CAT_2 | Character(2) | VARCHAR2(2) NOT NULL | End of Year Submissions - NI category code. |
| 133 | GPGB_LEL_2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings at LEL |
| 134 | GPGB_LEL_ET_2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above LEL up to ET |
| 135 | GPGB_ET_UEL_2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above ET up to UEL |
| 136 | GPGB_EE_NIC_2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Employee NIC |
| 137 | GPGB_EE_RBT_2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employee's rebate |
| 138 | GPGB_ER_NIC_2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's contributions |
| 139 | GPGB_ER_RBT_2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's rebate |
| 140 | GPGB_SCON_2 | Character(9) | VARCHAR2(9) NOT NULL | End of Year Submissions - SCON - Scheme Contracted Out Number |
| 141 | GPGB_NI_CAT_3 | Character(2) | VARCHAR2(2) NOT NULL | End of Year Submissions - NI category code. |
| 142 | GPGB_LEL_3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings at LEL |
| 143 | GPGB_LEL_ET_3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above LEL up to ET |
| 144 | GPGB_ET_UEL_3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above ET up to UEL |
| 145 | GPGB_EE_NIC_3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Employee NIC |
| 146 | GPGB_EE_RBT_3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employee's rebate |
| 147 | GPGB_ER_NIC_3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's contributions |
| 148 | GPGB_ER_RBT_3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's rebate |
| 149 | GPGB_SCON_3 | Character(9) | VARCHAR2(9) NOT NULL | End of Year Submissions - SCON - Scheme Contracted Out Number |
| 150 | GPGB_NI_CAT_4 | Character(2) | VARCHAR2(2) NOT NULL | End of Year Submissions - End of Year Submissions - NI category code. |
| 151 | GPGB_LEL_4 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings at LEL |
| 152 | GPGB_LEL_ET_4 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above LEL up to ET |
| 153 | GPGB_ET_UEL_4 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above ET up to UEL |
| 154 | GPGB_EE_NIC_4 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Employee NIC |
| 155 | GPGB_EE_RBT_4 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employee's rebate |
| 156 | GPGB_ER_NIC_4 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's contributions |
| 157 | GPGB_ER_RBT_4 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's rebate |
| 158 | GPGB_SCON_4 | Character(9) | VARCHAR2(9) NOT NULL | End of Year Submissions - SCON - Scheme Contracted Out Number |
| 159 | GPGB_SSP_REC | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Total SSP Recovered under PTS |
| 160 | GPGB_SMP_STD | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | SMP/SPP/SAP Recovery % |
| 161 | GPGB_SMP_SER | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | NIC Comp on SMP/SPP/SAP % |