HMCF_ORDER_VW (SQL View)	Index Back
Current Chartfield order This record aids in mapping original CF sequence to the configured CF sequence. Its construct with the join to PSRECFIELD record CHARTFLD_SBR ensures that we also get the appropriate sequence between inactive CFs where all fields have a CF_ORDER of 99.

HMCF_ORDER_VW

(SQL View)

Current Chartfield order

This record aids in mapping original CF sequence to the configured CF sequence. Its construct with the join to PSRECFIELD record CHARTFLD_SBR ensures that we also get the appropriate sequence between inactive CFs where all fields have a CF_ORDER of 99.

SELECT CF.FIELDNAME , CF.CF_ORDER , RF.FIELDNUM FROM PS_FS_CF_TEMPLATE CF , PSRECFIELD RF WHERE RF.RECNAME = 'CHARTFLD_SBR' AND RF.FIELDNAME = CF.FIELDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

2 CF_ORDER Number(2,0) SMALLINT NOT NULL ChartField Sequence Order

3 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	CF_ORDER	Number(2,0)	SMALLINT NOT NULL	ChartField Sequence Order
3	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number