White dot for spacing only
The Dice Project


Database Service Data Model


Table: 3g PPIP-HTBN-Feed  E3G#BOX_TDM 
Related Pages

Overview

Cluster Index
Table Index
Field Index
Key Index
Link Index

Name Index
Code Index

DB Table Index
DB Column Index

DB Size Statistics

Data Model Home
Home

Contains HR PPIP Management Information Universe data from BOXI for HTBN staff. Used to sync against local Duty Contract records.

Fields


The following box shows the 18 fields in this table.

Name Content Length Empty?
Category Character/Fixed 35 YES
Date of Birth Character/Fixed 14 YES
Employee# Numeric/Fixed 8 YES
FIS Account Code Character/Fixed 4 YES
FIS Cost Centre Character/Fixed 6 YES
FIS Job Code Character/Fixed 6 YES
Firstname Character/Fixed 25 YES
Grade Character/Fixed 4 YES
Grade Step Numeric/Fixed 4 YES
Job Segment 2 Character/Fixed 35 YES
Job Title Character/Fixed 35 YES
Lastname Character/Fixed 40 YES
NI# Character/Fixed 9 YES
Point Numeric/Fixed 4 YES
Primary Flag Character/Fixed 1 YES
Salary Numeric/Fixed 4 YES
Start Date Character/Fixed 14 YES
Title Character/Fixed 10 YES

Clusters


The following list shows the cluster containing this table.


Keys


There are no primary keys defined in this table.

There are no foreign keys posted into this table.

Links


There are no forward links from this table.

There are no reverse links from this table.

Schema


CREATE TABLE boxi_htbn_feed_3g (
employee_number INTEGER8,
title CHAR(10),
first_name CHAR(25),
last_name CHAR(40),
date_of_birth CHAR(14),
ni_number CHAR(9),
personal_job_title CHAR(35),
job_segment_2 CHAR(35),
employment_category CHAR(35),
grade CHAR(4),
grade_step INTEGER4,
spinal_point INTEGER4,
spinal_salary INTEGER4,
primary_flag CHAR(1),
start_date CHAR(14),
fis_account_code CHAR(4),
fis_cost_centre CHAR(6),
fis_job_code CHAR(6)
) WITH NODUPLICATES;


 : Doc : Database : Dm : Table 

Mini Informatics Logo - Link to Main Informatics Page
Please contact us with any comments or corrections.
Unless explicitly stated otherwise, all material is copyright The University of Edinburgh
Spacing Line