GPTH_PREFIX_VW (SQL View)	Index Back
The mapping view for Name Pre The mapping view for Name Prefix of Thailand code

GPTH_PREFIX_VW

(SQL View)

The mapping view for Name Pre

The mapping view for Name Prefix of Thailand code

SELECT T.NAME_PREFIX , T.GPTH_NAME_PRE_CODE , CASE WHEN (T.GPTH_NAME_PRE_CODE = '003') THEN 'Mr' WHEN (T.GPTH_NAME_PRE_CODE = '004') THEN 'Miss' WHEN (T.GPTH_NAME_PRE_CODE = '005') THEN 'Mrs' ELSE ' ' END AS GPTH_NAME_PRE_DIS FROM PS_GPTH_PREFIX_TBL T

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

2 GPTH_NAME_PRE_CODE Character(3) VARCHAR2(3) NOT NULL GP Thailand - Name Prefix Code Mr ---- 003 Miss --- 004 Mrs --- 005

3 GPTH_NAME_PRE_DIS Character(4) VARCHAR2(4) NOT NULL Name prefix description for GP Thailand.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
2	GPTH_NAME_PRE_CODE	Character(3)	VARCHAR2(3) NOT NULL	GP Thailand - Name Prefix Code Mr ---- 003 Miss --- 004 Mrs --- 005
3	GPTH_NAME_PRE_DIS	Character(4)	VARCHAR2(4) NOT NULL	Name prefix description for GP Thailand.