vPayrollEmployeePayTotals


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayrollYear smallint 2 null
PostingNumber int 4 null
PostingDate datetime 16,3 √ null
PostingCompleteFlag bit 1 √ null
ID int 4 null
FrequencyCode varchar 5 √ null
PayPeriods decimal 10,4 √ null
OverridePayMethodCode varchar 5 √ null
GrossPay money 21,4 √ null
HECS money 21,4 √ null
HELP money 21,4 √ null
TotalTaxation money 21,4 √ null
TaxationOverrideFlag bit 1 √ null
NettPay money 21,4 √ null
ChequeNumber int 4 √ null
EmployerSuperannuation money 21,4 √ null
SuperContributionTax money 21,4 √ null
Description varchar 255 √ null
NormalPay money 21,4 √ null
SalarySacrifice money 21,4 √ null
SalarySacrificeSuperannuation money 21,4 √ null
TaxableAllowances money 21,4 √ null
NonTaxableAllowances money 21,4 √ null
Deductions money 21,4 √ null
EmployeeSuperannuation money 21,4 √ null
TerminationPay money 21,4 √ null
OtherPaymentGross money 21,4 √ null
OtherPaymentWithholding money 21,4 √ null
ChequeDate datetime 16,3 √ null
BackPayTax money 21,4 √ null
BackPayHECS money 21,4 √ null
BackPayHELP money 21,4 √ null
PayrollEmployeeDocumentsSeq int 4 √ null
Category varchar 5 √ null
StartDate datetime 16,3 √ null
EmploymentStatus varchar 1 √ null
PayGroup varchar 5 √ null
ReferenceSuperBase money 21,4 √ null
AnnualAllowance money 21,4 √ null
AnnualSalary money 21,4 √ null
CalculateAnnualSalaryFlag bit 1 √ null
AnnualBudget money 21,4 √ null
GroupCertPrintedFlag bit 1 √ null
GroupCertATONotifiedFlag bit 1 √ null
TaxFileNumber int 4 √ null
TaxScale varchar 3 √ null
TaxDependantRebate money 21,4 √ null
TaxHECSFlag bit 1 √ null
TaxHELPFlag bit 1 √ null
TerminatedFlag bit 1 √ null
TerminationDate datetime 16,3 √ null
PayrollEmployeeComment varchar 2147483647 √ null
GroupCertPrintedDate datetime 16,3 √ null
GroupCertATONotifiedDate datetime 16,3 √ null
FringeBenefitsTax money 21,4 √ null
IDType varchar 1 √ null
AddressID int 4 √ null
SpouseID int 4 √ null
SpouseFlag bit 1 √ null
NameInternal varchar 100 √ null
NameExternal varchar 100 √ null
LegalFullName varchar 150 √ null
Surname varchar 30 √ null
SurnamePrevious varchar 30 √ null
Title varchar 30 √ null
Initials varchar 15 √ null
Suffix varchar 20 √ null
Preferred varchar 20 √ null
PreferredFormal varchar 20 √ null
Given1 varchar 20 √ null
Given2 varchar 50 √ null
OccupCode varchar 15 √ null
OccupDesc varchar 50 √ null
OccupCompany varchar 50 √ null
OccupIndustryCode varchar 8 √ null
OccupPositionCode varchar 8 √ null
OccupPhone varchar 15 √ null
OccupFax varchar 15 √ null
OccupEmail varchar 100 √ null
MailFormat varchar 1 √ null
SalutFormat varchar 1 √ null
BirthDate datetime 16,3 √ null
DeceasedDate datetime 16,3 √ null
DeceasedFlag bit 1 √ null
Gender varchar 15 √ null
MobilePhone varchar 15 √ null
Email varchar 100 √ null
ReligionCode varchar 5 √ null
CountryOfBirthCode varchar 5 √ null
HomeLanguageCode varchar 5 √ null
Education varchar 255 √ null
Qualifications varchar 255 √ null
HighestSecondaryYearLevel tinyint 1 √ null
LastYearOfStudy int 4 √ null
MaritalStatus varchar 1 √ null
MailNamePrimary varchar 100 √ null
MailNameJoint varchar 100 √ null
MailSalutationPrimary varchar 100 √ null
MailSalutationJoint varchar 100 √ null
OccupAddress1 varchar 40 √ null
OccupAddress2 varchar 40 √ null
OccupAddress3 varchar 40 √ null
OccupSuburb varchar 40 √ null
OccupState varchar 5 √ null
OccupCountryCode varchar 5 √ null
OccupPostCode varchar 5 √ null
OccupMobilePhone varchar 15 √ null
CommunityComment varchar 2147483647 √ null
Biography varchar 2147483647 √ null
OccupAddressFull varchar 200 √ null
OccupAddressComma varchar 200 √ null
ParishCode varchar 5 √ null
NationalityCode varchar 5 √ null
Nationality2Code varchar 5 √ null
InitialsOverrideFlag bit 1 √ null
OccupCompanyAttn varchar 40 √ null
DefaultEmailCode varchar 1 √ null
InstallCountryCode varchar 8000 √ null
GenderSynergyMeaning varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views