HP_CDN_DISTUERN (SQL View)	Index Back
CDN Retro Dist Updates View for Allowable update fields in Direct Retro Distribution

HP_CDN_DISTUERN

(SQL View)

CDN Retro Dist Updates

View for Allowable update fields in Direct Retro Distribution

SELECT HP_FIELD_DESCR , HP_FIELD_TYPE , HP_FIELD_LENGTH , HP_USE_SPACES FROM PS_HP_DIST_FLDS WHERE COUNTRY IN ('GBL', 'CAN') AND UPDATE_FLAG = 'Y' AND (HP_BUDGET_DATATYPE = ' ' OR HP_BUDGET_DATATYPE = 'E')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HP_FIELD_DESCR Character(30) VARCHAR2(30) NOT NULL Field Description for use by Retro Distribution query

2 HP_FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Numeric or Character field.
C=Character
N=Numeric

3 HP_FIELD_LENGTH Number(3,0) SMALLINT NOT NULL Length og field, to be tested at field edti.

4 HP_USE_SPACES Character(1) VARCHAR2(1) NOT NULL Allowed to search and uodate with spaces. IE Field on database actually can contain space, not required.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HP_FIELD_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Field Description for use by Retro Distribution query
2	HP_FIELD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Numeric or Character field. C=Character N=Numeric
3	HP_FIELD_LENGTH	Number(3,0)	SMALLINT NOT NULL	Length og field, to be tested at field edti.
4	HP_USE_SPACES	Character(1)	VARCHAR2(1) NOT NULL	Allowed to search and uodate with spaces. IE Field on database actually can contain space, not required.