NID_PR_GBR_VW (SQL View)	Index Back
NID Prefix GBR - View National Insurance Number Prefix view, showing distinct NID Prefix values regardless of Effective Date/Status.

NID_PR_GBR_VW

National Insurance Number Prefix view, showing distinct NID Prefix values regardless of Effective Date/Status.

SELECT DISTINCT NID_PREFIX FROM PS_NID_PREFIX_GBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 NID_PREFIX Character(2) VARCHAR2(2) NOT NULL NID_PREFIX