PICS Database Upgrade 21.00.004

The database upgrade released Friday 4th February 2022 removes a number of redundant fields from the PICS Database. These fields have not be in use in data capture for a number of years.

Table

Fields

Table

Fields

APPLIC

CENTRE

ENTRY
L27RESTUSE

OTHERSYSID

PREVWORK

PROGCODE

PROGRAMME

REDUNDANCY
SPECNEEDS
SSACODE

EPIDATA

BSKILLCRS
CONNEX_OK
CONVIN
CONVTO
EMP_DATE
FR_NEWDEAL
INI_STNP
L29_ADSUP
L49_DLS5
PREV_WEEKS
RESTRICTED
SIC
TRY_QUAL
VQ_END

pcExHist

AIMCOUNT
LEARNERCOUNT

pcSessAt

CONNEXSTS

pcTrnDet

DOB_EST
DPA_SIGNED
EPORTPAS
MARITALST
PELL_HOSTED_SURVEYS_GUID
SURVLID
WEBSITE
WORKPHONE

Placemnt

AREA
BDFUNDORG
CONTACTPREFSERVICES
TEXTPHONE
WEBUSER

TrEdu

ALEVELS
DIRECTIONS
GCSE_AC
GCSE_DG
GNVQ
INQUAL
NVQ_0
NVQ_1
NVQ_2
NVQ_3
NVQ_4
OUTQUAL
PLUSEND
PLUSLIT
PLUSLIT12
PLUSLITEND
PLUSNUM
PLUSNUM12
PLUSNUMEND
PLUSSTART
POST16_LEV
PREV_EXP
TOP_QUAL