GPNZ_BANKID_RNG (SQL Table)	Index Back
Valid Branches for NZL Banks This table stores the range of valid branch's codes for the Bank's codes in New Zealand.

GPNZ_BANKID_RNG

(SQL Table)

Valid Branches for NZL Banks

This table stores the range of valid branch's codes for the Bank's codes in New Zealand.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

2 GPNZ_BRANCH_ID_BEG Number(4,0) SMALLINT NOT NULL This field stores the Branch id range's starting id for New Zealand Banlk Account validation process.

3 GPNZ_BRANCH_ID_END Number(4,0) SMALLINT NOT NULL This field stores the ending Branch Id of Bank Id's corresponding Branch Id range.

4 GPNZ_ACC_VAL_ALG Character(1) VARCHAR2(1) NOT NULL This field stores the type of Algorithm that needs to be used for validation of the Account base number.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
2	GPNZ_BRANCH_ID_BEG	Number(4,0)	SMALLINT NOT NULL	This field stores the Branch id range's starting id for New Zealand Banlk Account validation process.
3	GPNZ_BRANCH_ID_END	Number(4,0)	SMALLINT NOT NULL	This field stores the ending Branch Id of Bank Id's corresponding Branch Id range.
4	GPNZ_ACC_VAL_ALG	Character(1)	VARCHAR2(1) NOT NULL	This field stores the type of Algorithm that needs to be used for validation of the Account base number.