|
![]() |
Property | Value |
Name | PERSONNEL_CODES_1_A |
Schema | dbo |
Row Count | 9189 |
Data Size | 1400 KB |
Index Size | 184 KB |
Create Date | 11/5/2012 9:54 AM |
Description |
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
![]() |
![]() |
ADD_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ADD_PGM |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ADD_TIME |
varchar(7) |
True |
False |
False |
|||
![]() |
![]() |
ADD_USER_ID |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ALLOW_OPTIONS_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
ASSIGNMENTS_TO_BE_PAID_ON_FLAG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
ATTENDANCE_DUE_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ATTENDANCE_END_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ATTENDANCE_START_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
BEN_DED_RATE_CODE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
BEN_DED_RATE_CODE_D |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
BENEFIT_CODE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
BENEFIT_CODE_D |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
BENEFIT_DEDUCTION_SUPPRESS_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
BENEFIT_TYPE_CODE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
BENEFIT_TYPE_CODE_B |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
BUDGET_IND |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
CALENDAR_CODE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
CALENDAR_CODE_CM |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
CALENDAR_CODE_CPP |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
CALENDAR_CODE_CY |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
CALENDAR_MONTH |
varchar(6) |
True |
False |
False |
|||
![]() |
![]() |
CALENDAR_PERIOD_INTERNAL_ID |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
CALENDAR_YEAR_PAID_DAYS |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
CALENDAR_YEAR_YYYY |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
CALENDAR_YR_PAID_DAYS |
numeric(17, 2) |
True |
False |
False |
|||
![]() |
![]() |
CATEGORY_CODE |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
CCPA_RULE_CODE |
varchar(10) |
True |
False |
False |
|||
![]() |
![]() |
DAYS_PER_PAY |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
DAYS_PER_PAY_METHOD_CALC |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
DEDUCT_CLASS_CODE |
varchar(3) |
True |
False |
False |
|||
![]() |
![]() |
DEDUCTION_CODE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
DEDUCTION_EMPL_MAX_LIMITED_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
DEDUCTION_SUPPRESS_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
DEDUCTION_TYPE_CODE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
DEDUCTION_TYPE_CODE_D |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
DEFERRED_COMPENSATION_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
DESCRIPTION |
varchar(50) |
True |
False |
False |
|||
![]() |
![]() |
EMPLOYEE_ELIGIBLE |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
END_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
EQUAL_PAYS_PER_YEAR |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
EXPENSE_GL_CODE |
varchar(5) |
True |
False |
False |
|||
![]() |
![]() |
EXPENSE_QUAL_2 |
varchar(4) |
True |
False |
False |
|||
![]() |
![]() |
FACE_VALUE_IND |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
FACE_VALUE_MAX |
numeric(17, 2) |
True |
False |
False |
|||
![]() |
![]() |
GL_ACCT_NO |
varchar(25) |
True |
False |
False |
|||
![]() |
![]() |
HOLD |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
IRS_PAYROLL_FREQUENCY |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ISN_PERSONNEL_CODES_1_A |
int(10, 0) |
False |
False |
False |
|||
![]() |
![]() |
MAINT_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
MAINT_PGM |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
MAINT_TIME |
varchar(7) |
True |
False |
False |
|||
![]() |
![]() |
MAINT_USER_ID |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
MAX_GROSS_TAXED_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
![]() |
![]() |
MAX_TAX_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
![]() |
![]() |
OPTIONAL_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
PAY_CHECK_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAY_CHECK_PROCESSED_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
PAY_END_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAY_FREQUENCY_CODE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAY_FREQUENCY_CODE_B |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAY_FREQUENCY_CODE_BEN_DED |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAY_FREQUENCY_CODE_C |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAY_FREQUENCY_CODE_D |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAY_FREQUENCY_CODE_TXT |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAY_START_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAY_TO_EMPLOYEE_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
PAYPERIOD_EXEMPT_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
![]() |
![]() |
PAYS_PER_MONTH |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
PAYS_PER_YEAR_TAX |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
PDB_BENEFIT_TYPE |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
PENSION_PLAN_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
PRIORITY_OVERRIDE_ALLOW_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
PRIORITY_SEQ_NBR_D |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
REQUIRED_MAX_AMOUNT |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
REQUIRED_MIN_AMOUNT |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
RETIREMENT_PLAN |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
![]() |
![]() |
SCHEDULE_IS_PREDICTABLE_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
START_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
START_DATE_9C |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
STATUS |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
SUPPL_TYPE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
SUPPRESS_DEDUCTIONS_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
TARGET_SALARY_CODE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
TAX_ADDITIONAL_CHECK_PCT |
numeric(17, 3) |
True |
False |
False |
|||
![]() |
![]() |
TAX_ANNUALIZED_MIN_MAX_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
TAX_MARITAL_CODE |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
TAX_START_AMT |
numeric(17, 2) |
True |
False |
False |
|||
![]() |
![]() |
TAX_TYPE_CODE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
TAX_TYPE_CODE_TB |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
TAX_TYPE_GL_CODE |
varchar(5) |
True |
False |
False |
|||
![]() |
![]() |
TAX_TYPE_QUAL_2 |
varchar(4) |
True |
False |
False |
|||
![]() |
![]() |
TAXABLE_FLAG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
TAXABLE_LIFE_INS |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
TAXABLE_PORTION_RATE_CODE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
TIME_TYPE_ACCRUAL_IND |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
VENDOR_CODE |
varchar(9) |
True |
False |
False |
|||
![]() |
![]() |
VENDOR_CODE_D |
varchar(9) |
True |
False |
False |
|||
![]() |
![]() |
VENDOR_SEQ_NBR |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
W2_GROSS_BOX |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
W2_TAX_BOX |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
WORK_MONTHS |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
YEAR_TYPE |
varchar(1) |
True |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_PERSONNEL_CODES_1_A |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
Name | Type |
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[PERSONNEL_CODES_1_A] Script Date: 03/09/2017 16:45:49 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[PERSONNEL_CODES_1_A]( [ISN_PERSONNEL_CODES_1_A] [int] NOT NULL, [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [HOLD] [int] NULL, [DESCRIPTION] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [START_DATE_9C] [int] NULL, [END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAY_FREQUENCY_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAYS_PER_MONTH] [int] NULL, [DAYS_PER_PAY] [int] NULL, [PAYS_PER_YEAR_TAX] [int] NULL, [DAYS_PER_PAY_METHOD_CALC] [bit] NULL, [EQUAL_PAYS_PER_YEAR] [int] NULL, [TAX_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [OPTIONAL_IND] [bit] NULL, [TAX_TYPE_GL_CODE] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TAX_TYPE_QUAL_2] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TAX_TYPE_CODE_TB] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TAX_MARITAL_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAY_FREQUENCY_CODE_TXT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAYPERIOD_EXEMPT_AMOUNT] [numeric](17, 2) NULL, [MAX_GROSS_TAXED_AMOUNT] [numeric](17, 2) NULL, [MAX_TAX_AMOUNT] [numeric](17, 2) NULL, [TAX_ADDITIONAL_CHECK_PCT] [numeric](17, 3) NULL, [TAX_ANNUALIZED_MIN_MAX_IND] [bit] NULL, [BENEFIT_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ASSIGNMENTS_TO_BE_PAID_ON_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BENEFIT_DEDUCTION_SUPPRESS_IND] [bit] NULL, [GL_ACCT_NO] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BENEFIT_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BENEFIT_TYPE_CODE_B] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [VENDOR_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BEN_DED_RATE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TAXABLE_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAY_TO_EMPLOYEE_IND] [bit] NULL, [PAY_FREQUENCY_CODE_B] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TAX_START_AMT] [numeric](17, 2) NULL, [CALENDAR_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ATTENDANCE_DUE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ATTENDANCE_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ATTENDANCE_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAY_CHECK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAY_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAY_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAY_FREQUENCY_CODE_C] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAY_FREQUENCY_CODE_BEN_DED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SCHEDULE_IS_PREDICTABLE_IND] [bit] NULL, [YEAR_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CALENDAR_CODE_CM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CALENDAR_MONTH] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CALENDAR_CODE_CPP] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CALENDAR_PERIOD_INTERNAL_ID] [int] NULL, [TIME_TYPE_ACCRUAL_IND] [bit] NULL, [PAY_CHECK_PROCESSED_IND] [bit] NULL, [CALENDAR_CODE_CY] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CALENDAR_YEAR_YYYY] [int] NULL, [CALENDAR_YEAR_PAID_DAYS] [int] NULL, [DEDUCTION_TYPE_CODE_D] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DEDUCTION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAY_FREQUENCY_CODE_D] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BEN_DED_RATE_CODE_D] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PRIORITY_SEQ_NBR_D] [int] NULL, [ALLOW_OPTIONS_IND] [bit] NULL, [BENEFIT_CODE_D] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [VENDOR_CODE_D] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TARGET_SALARY_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DEDUCTION_EMPL_MAX_LIMITED_IND] [bit] NULL, [DEDUCTION_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PRIORITY_OVERRIDE_ALLOW_IND] [bit] NULL, [DEFERRED_COMPENSATION_IND] [bit] NULL, [TAXABLE_PORTION_RATE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EMPLOYEE_ELIGIBLE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CALENDAR_YR_PAID_DAYS] [numeric](17, 2) NULL, [REQUIRED_MAX_AMOUNT] [int] NULL, [SUPPL_TYPE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [REQUIRED_MIN_AMOUNT] [int] NULL, [WORK_MONTHS] [int] NULL, [BUDGET_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RETIREMENT_PLAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [W2_GROSS_BOX] [int] NULL, [PDB_BENEFIT_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [W2_TAX_BOX] [int] NULL, [FACE_VALUE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EXPENSE_GL_CODE] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EXPENSE_QUAL_2] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FACE_VALUE_MAX] [numeric](17, 2) NULL, [SUPPRESS_DEDUCTIONS_IND] [bit] NULL, [DEDUCTION_SUPPRESS_IND] [bit] NULL, [VENDOR_SEQ_NBR] [int] NULL, [PENSION_PLAN_IND] [bit] NULL, [IRS_PAYROLL_FREQUENCY] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TAXABLE_LIFE_INS] [bit] NULL, [CCPA_RULE_CODE] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DEDUCT_CLASS_CODE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CATEGORY_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
ADD_DATE | ADD_PGM | ADD_TIME | ADD_USER_ID | ALLOW_OPTIONS_IND | ASSIGNMENTS_TO_BE_PAID_ON_FLAG | ATTENDANCE_DUE_DATE | ATTENDANCE_END_DATE | ATTENDANCE_START_DATE | BEN_DED_RATE_CODE | BEN_DED_RATE_CODE_D | BENEFIT_CODE | BENEFIT_CODE_D | BENEFIT_DEDUCTION_SUPPRESS_IND | BENEFIT_TYPE_CODE | BENEFIT_TYPE_CODE_B | BUDGET_IND | CALENDAR_CODE | CALENDAR_CODE_CM | CALENDAR_CODE_CPP | CALENDAR_CODE_CY | CALENDAR_MONTH | CALENDAR_PERIOD_INTERNAL_ID | CATEGORY_CODE | CCPA_RULE_CODE | DAYS_PER_PAY_METHOD_CALC | DEDUCT_CLASS_CODE | DEDUCTION_CODE | DEDUCTION_EMPL_MAX_LIMITED_IND | DEDUCTION_SUPPRESS_IND | DEDUCTION_TYPE_CODE | DEDUCTION_TYPE_CODE_D | DEFERRED_COMPENSATION_IND | DESCRIPTION | EMPLOYEE_ELIGIBLE | END_DATE | EXPENSE_GL_CODE | EXPENSE_QUAL_2 | FACE_VALUE_IND | GL_ACCT_NO | HOLD | IRS_PAYROLL_FREQUENCY | ISN_PERSONNEL_CODES_1_A | MAINT_DATE | MAINT_PGM | MAINT_TIME | MAINT_USER_ID | OPTIONAL_IND | PAY_CHECK_DATE | PAY_CHECK_PROCESSED_IND | PAY_END_DATE | PAY_FREQUENCY_CODE | PAY_FREQUENCY_CODE_B | PAY_FREQUENCY_CODE_BEN_DED | PAY_FREQUENCY_CODE_C | PAY_FREQUENCY_CODE_D | PAY_FREQUENCY_CODE_TXT | PAY_START_DATE | PAY_TO_EMPLOYEE_IND | PDB_BENEFIT_TYPE | PENSION_PLAN_IND | PRIORITY_OVERRIDE_ALLOW_IND | RETIREMENT_PLAN | RowUpdatedOn | SCHEDULE_IS_PREDICTABLE_IND | START_DATE | STATUS | SUPPL_TYPE | SUPPRESS_DEDUCTIONS_IND | TARGET_SALARY_CODE | TAX_ANNUALIZED_MIN_MAX_IND | TAX_MARITAL_CODE | TAX_TYPE_CODE | TAX_TYPE_CODE_TB | TAX_TYPE_GL_CODE | TAX_TYPE_QUAL_2 | TAXABLE_FLAG | TAXABLE_LIFE_INS | TAXABLE_PORTION_RATE_CODE | TIME_TYPE_ACCRUAL_IND | VENDOR_CODE | VENDOR_CODE_D | YEAR_TYPE |
20120523 | PEC073N2 | 1439446 | E001501 | false | 20121108 | 20121115 | 20121101 | false | 228RLONG | 4682 | false | false | false | false | 1439446 | 7421 | false | 20121115 | false | 20121115 | 20121101 | false | false | false | 2017-02-06T11:20:38.191-05:00 | false | false | false | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||
20030522 | PEC073N2 | 1309422 | E001501 | false | 20040408 | 20040415 | 20040401 | false | ADJUNCT | 2034 | false | false | false | false | 1309422 | 3672 | false | 20040415 | false | 20040415 | 20040401 | false | false | false | 2017-02-06T11:20:37.411-05:00 | false | false | false | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||
20100429 | PEC073N2 | 0943538 | E001501 | false | 20110221 | 20110228 | 20110216 | false | 168/24 | 4051 | false | false | false | false | 943538 | 6405 | false | 20110228 | false | 20110228 | 20110216 | false | false | false | 2017-02-06T11:20:37.989-05:00 | false | false | false | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||
20100429 | PEC070N2 | 0925431 | E001501 | false | false | 168 | 201103 | false | false | false | false | 925431 | 6361 | false | false | false | false | false | 2017-02-06T11:20:37.989-05:00 | false | false | false | false | true | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
20080508 | PEC073N2 | 0951537 | E001501 | false | 20080822 | 20080831 | 20080816 | false | 210A/24 | 3537 | false | false | false | false | 951537 | 5501 | false | 20080829 | false | 20080831 | 20080816 | false | false | false | 2017-02-06T11:20:37.77-05:00 | false | false | false | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||
20060407 | PEC070N2 | 0931473 | E001501 | false | false | 210A/24 | 200704 | false | false | false | false | 931473 | 4680 | false | false | false | false | false | 2017-02-06T11:20:37.614-05:00 | false | false | false | false | true | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
20100429 | PEC070N2 | 0947262 | E001501 | false | false | 198A/24 | 201104 | false | false | false | false | 947262 | 6423 | false | false | false | false | false | 2017-02-06T11:20:37.989-05:00 | false | false | false | false | true | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
20000518 | PEC073N2 | 0812474 | CWHITE | false | 20001024 | 20001031 | 20001016 | false | 228KRULL | 999 | false | false | false | false | 812474 | 1842 | false | 20001031 | false | 20001031 | 20001016 | false | false | false | 2017-02-06T11:20:37.053-05:00 | false | false | false | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||
20150519 | PEC073N2 | 1445266 | E077593 | false | 20160108 | 20160115 | 20160101 | false | 260 DAY | 5448 | false | false | false | false | 1445266 | 8444 | false | 20160115 | false | 20160115 | 20160101 | false | false | false | 2017-02-06T11:20:38.394-05:00 | false | false | false | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||
20080508 | PEC070N2 | 0935079 | E001501 | false | false | 198A/24 | 200810 | false | false | false | false | 935079 | 5407 | false | false | false | false | false | 2017-02-06T11:20:37.755-05:00 | false | false | false | false | true |
Powered by BI Documenter |