HP_CDN_DIST_DED

(SQL View)
Index Back

CDN Retro Dist Select Fields

View for Allowable select 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 (HP_BUDGET_DATATYPE = ' ' OR HP_BUDGET_DATATYPE = 'D')

# 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.