PROCESS_INSTANCEDefault Value: 1
D=Delete Run
S=Standard Run
A=Annually
M=Monthly
Q=Quarterly
E=Effective Date
P=Period Thru Date
N=No
Y=Yes
TC_PAYEXT_AET(SQL Table) |
Index Back |
|---|---|
Cache record for Payroll ExtCache record for the Payroll Extract programs for Total Compensations |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Default Value: 1 |
| 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 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 5 | TC_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Total Comp Plan ID |
| 6 | EFFDT | Date(10) | DATE | Effective Date |
| 7 | EXTRACT_PROGRAM | Character(12) | VARCHAR2(12) NOT NULL | Extract Program |
| 8 | FROM_DATE | Date(10) | DATE | From Date |
| 9 | THRU_DATE | Date(10) | DATE | Thru Date |
| 10 | TC_RUN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Total Comp Extract Run Type
D=Delete Run S=Standard Run |
| 11 | RUN_DTTM | DateTime(26) | TIMESTAMP | Run Date and Time |
| 12 | FROM_DT_WRK | Date(10) | DATE | From Date Work Field |
| 13 | THRU_DT_WRK | Date(10) | DATE | Thru Date Work |
| 14 | CONTINUE_AE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Continue AE Processing flag |
| 15 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 16 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 17 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 18 | PAY_BEGIN_DT | Date(10) | DATE | Pay Period Begin Date |
| 19 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 20 | CHECK_DT | Date(10) | DATE | Check date. |
| 21 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 22 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Base Currency |
| 23 | IF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | If flag |
| 24 | DLT_DETL_SW | Character(1) | VARCHAR2(1) NOT NULL | Delete Detail Switch |
| 25 | DO_EXTRACT_SW | Character(1) | VARCHAR2(1) NOT NULL | Do Extract Switch |
| 26 | BLD_CNTL_SW | Character(1) | VARCHAR2(1) NOT NULL | Build Payroll AE Control |
| 27 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 28 | TC_FREQ | Character(1) | VARCHAR2(1) NOT NULL |
Period Frequency
A=Annually M=Monthly Q=Quarterly |
| 29 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 30 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 31 | CUR_EFFDT | Date(10) | DATE | Currency Effective Date |
| 32 | CUR_EFFDT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Effective Date Flag
E=Effective Date P=Period Thru Date |
| 33 | CUR_EFFDT_RUN | Date(10) | DATE | Currency Exchange Rate Effdt |
| 34 | TC_FREQ_FACTOR | Number(9,4) | DECIMAL(8,4) NOT NULL | Frequency Annual Factor |
| 35 | TC_FROZEN | Character(1) | VARCHAR2(1) NOT NULL |
Plan Frozen
N=No Y=Yes |
| 36 | EXTRACT_PROGRAMWRK | Character(8) | VARCHAR2(8) NOT NULL | Extract Program |
| 37 | FROM_CUR | Character(3) | VARCHAR2(3) NOT NULL | From Currency Code |
| 38 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 39 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 40 | COMPENSATION_ID | Character(10) | VARCHAR2(10) NOT NULL | Compensation ID |
| 41 | TC_COMP_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Compensation Source |
| 42 | THRUDATE | Date(10) | DATE | End Date |
| 43 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 44 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 45 | FROM_PAYROLL_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Payroll Amount |
| 46 | TO_PAYROLL_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Converted Payroll Amount |