White dot for spacing only
The Dice Project

Database Service Data Model

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


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

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


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


The following list shows the cluster containing this table.


There are no primary keys defined in this table.

There are no foreign keys posted into this table.


There are no forward links from this table.

There are no reverse links from this table.


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)

 : 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