NID_PR_GBR_DISP

(SQL Table)
Index Back

NID Prefix GBR - UI Display

Used to display the NID Prefix values for the UK. Allows the values to be displayed across the page in a similar way to the information sheet supplied by the Inland Revenue. NOTE: although defined as a table, this record is really 'derived' with no rows stored in the database.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 NID_PREFIX_VAL_1 Number(3,0) SMALLINT NOT NULL NID_PREFIX
2 NID_PREFIX_VAL_2 Number(3,0) SMALLINT NOT NULL NID_PREFIX
3 NID_PREFIX_VAL_3 Number(3,0) SMALLINT NOT NULL NID_PREFIX
4 NID_PREFIX_VAL_4 Number(3,0) SMALLINT NOT NULL NID_PREFIX
5 NID_PREFIX_VAL_5 Number(3,0) SMALLINT NOT NULL NID_PREFIX
6 NID_PREFIX_VAL_6 Number(3,0) SMALLINT NOT NULL NID_PREFIX
7 NID_PREFIX_VAL_7 Number(3,0) SMALLINT NOT NULL NID_PREFIX
8 NID_PREFIX_VAL_8 Number(3,0) SMALLINT NOT NULL NID_PREFIX
9 NID_PREFIX_VAL_9 Number(3,0) SMALLINT NOT NULL NID_PREFIX
10 NID_PREFIX_VAL_10 Number(3,0) SMALLINT NOT NULL NID_PREFIX
11 NID_PREFIX_VAL_11 Number(3,0) SMALLINT NOT NULL NID_PREFIX
12 NID_PREFIX_VAL_12 Number(3,0) SMALLINT NOT NULL NID_PREFIX
13 NID_PREFIX_VAL_13 Number(3,0) SMALLINT NOT NULL NID_PREFIX
14 NID_PREFIX_VAL_14 Number(3,0) SMALLINT NOT NULL NID_PREFIX
15 NID_PREFIX_VAL_15 Number(3,0) SMALLINT NOT NULL NID_PREFIX
16 NID_PREFIX_VAL_16 Number(3,0) SMALLINT NOT NULL NID_PREFIX
17 NID_PREFIX_VAL_17 Number(3,0) SMALLINT NOT NULL NID_PREFIX
18 NID_PREFIX_VAL_18 Number(3,0) SMALLINT NOT NULL NID_PREFIX
19 NID_PREFIX_VAL_19 Number(3,0) SMALLINT NOT NULL NID_PREFIX
20 NID_PREFIX_VAL_20 Number(3,0) SMALLINT NOT NULL NID_PREFIX
21 NID_PREFIX_VAL_21 Number(3,0) SMALLINT NOT NULL NID_PREFIX
22 NID_PREFIX_VAL_22 Number(3,0) SMALLINT NOT NULL NID_PREFIX