Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PayrollYear | smallint | 2 | √ | null |
|
|
||
| ID | int | 4 | √ | null |
|
|
||
| EmployeeCategory | varchar | 5 | √ | null |
|
|
||
| EmployeeStartDate | datetime | 16,3 | √ | null |
|
|
||
| EmploymentStatus | varchar | 1 | √ | null |
|
|
||
| EmploymentStatusDescription | varchar | 50 | √ | null |
|
|
||
| EmploymentStatusContractFlag | smallint | 2 | √ | null |
|
|
||
| EmploymentStatusSynergyMeaning | varchar | 10 | √ | null |
|
|
||
| EmployeeAnnualAllowance | money | 21,4 | √ | null |
|
|
||
| EmployeeAnnualSalary | money | 21,4 | √ | null |
|
|
||
| EmployeeCalcAnnualSalary | bit | 1 | √ | null |
|
|
||
| EmployeeAnnualBudget | money | 21,4 | √ | null |
|
|
||
| EmployeeGroupCertPrinted | bit | 1 | √ | null |
|
|
||
| EmployeeGroupCertPrintedDate | datetime | 16,3 | √ | null |
|
|
||
| EmployeeGroupCertATONotified | bit | 1 | √ | null |
|
|
||
| EmployeeGroupCertATONotifiedDate | datetime | 16,3 | √ | null |
|
|
||
| EmployeeTaxFileNumber | int | 4 | √ | null |
|
|
||
| EmployeeTaxScale | varchar | 3 | √ | null |
|
|
||
| EmployeeTaxDependantRebate | money | 21,4 | √ | null |
|
|
||
| EmployeeTaxHECSFlag | bit | 1 | √ | null |
|
|
||
| EmployeeTaxHELPFlag | bit | 1 | √ | null |
|
|
||
| EmployeeFringeBenefitsTax | money | 21,4 | √ | null |
|
|
||
| EmployeeTerminated | bit | 1 | √ | null |
|
|
||
| EmployeeTerminationDate | datetime | 16,3 | √ | null |
|
|
||
| ReferenceSuperBase | money | 21,4 | √ | null |
|
|
||
| EmployeeNameInternal | varchar | 100 | √ | null |
|
|
||
| EmployeeNameExternal | varchar | 100 | √ | null |
|
|
||
| EmployeeLegalFullName | varchar | 150 | √ | null |
|
|
||
| EmployeeSurname | varchar | 30 | √ | null |
|
|
||
| EmployeePreferred | varchar | 20 | √ | null |
|
|
||
| EmployeePreferredFormal | varchar | 20 | √ | null |
|
|
||
| EmployeeMailName | varchar | 100 | √ | null |
|
|
||
| BirthDate | datetime | 16,3 | √ | null |
|
|
||
| EmployeePayGroup | varchar | 5 | √ | null |
|
|
||
| PayFrequency | varchar | 5 | √ | null |
|
|
||
| StandardPayCode | varchar | 10 | √ | null |
|
|
||
| StandardPaySeq | smallint | 2 | null |
|
|
|||
| StandardPayModifiedBy | varchar | 50 | √ | null |
|
|
||
| StandardPayModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| StandardPayGLCodeSource | char | 1 | √ | null |
|
|
||
| StandardPayGLCode | varchar | 15 | √ | null |
|
|
||
| StandardPayGLSubAllocSource | char | 1 | √ | null |
|
|
||
| StandardPayGLSubAllocationCode | varchar | 15 | √ | null |
|
|
||
| StandardPayRateSource | char | 1 | √ | null |
|
|
||
| StandardPayRate | decimal | 12,5 | √ | null |
|
|
||
| StandardPayUnitsSource | char | 1 | √ | null |
|
|
||
| StandardPayUnits | decimal | 12,5 | √ | null |
|
|
||
| StandardPayFactorSource | char | 1 | √ | null |
|
|
||
| StandardPayFactor | decimal | 12,8 | √ | null |
|
|
||
| StandardPayAmountSource | char | 1 | √ | null |
|
|
||
| StandardPayAmount | money | 21,4 | √ | null |
|
|
||
| StandardPayDescription | varchar | 50 | √ | null |
|
|
||
| StandardPayFTE | decimal | 8,4 | √ | null |
|
|
||
| StandardPayCampusCode | varchar | 5 | √ | null |
|
|
||
| StandardPayCensusClass | varchar | 5 | √ | null |
|
|
||
| StandardPaySuperannuationMemberNumber | varchar | 20 | √ | null |
|
|
||
| StandardPayStopSuperAutoCalculationFlag | bit | 1 | √ | null |
|
|
||
| PayCodeDescription | varchar | 50 | √ | null |
|
|
||
| PayCodeType | varchar | 3 | √ | null |
|
|
||
| PayCodeTypeDescription | varchar | 45 | √ | null |
|
|
||
| StaffDepartment | varchar | 15 | √ | null |
|
|
||
| StaffCategory | varchar | 15 | √ | null |
|
|
||
| StaffBuilding | varchar | 15 | √ | null |
|
|
||
| StaffCampus | varchar | 3 | √ | null |
|
|
||
| StaffRoom | varchar | 15 | √ | null |
|
|
||
| StaffYearLevel | smallint | 2 | √ | null |
|
|
||
| StandardPayStartDate | datetime | 16,3 | √ | null |
|
|
||
| StandardPayStopDate | datetime | 16,3 | √ | null |
|
|
Table contained 0 rows