HMCF_CF_VW

(SQL View)
 Index Back

HMCF_CF_VW


SELECT A.ORIG_CF_NAME , A.CF_ACTIVE_STATUS , A.AFFILIATE_TYPE , A.RECNAME , ' ' , A.FIELDNAME , ' ' , ' ' , ' ' , ' ' , CF_ORDER , PREV_CF_ORDER , 0 , 0 , A.AFF_RELATED_CF , ' ' FROM PS_FS_CF_TEMPLATE A WHERE (A.CF_ACTIVE_STATUS = 'A' AND NOT EXISTS ( SELECT B.ORIG_CF_NAME FROM PS_FS_CF_ACT_LOG B WHERE B.ORIG_CF_NAME = A.ORIG_CF_NAME AND B.CF_ACTIVE_STATUS= 'A' AND B.CF_TMPLT_ACTION = 'I')) OR (A.CF_ACTIVE_STATUS = 'I' AND EXISTS ( SELECT C.ORIG_CF_NAME FROM PS_FS_CF_ACT_LOG C WHERE C.ORIG_CF_NAME = A.ORIG_CF_NAME AND C.CF_ACTIVE_STATUS= 'I' AND C.CF_TMPLT_ACTION = 'I'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ORIG_CF_NAME Character(18) VARCHAR2(18) NOT NULL Holds the Original Chartfield Name. This will not change!
2 CF_ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL The user can specify CF to be Active, Inactive or Deleted. This field was formerly called User Option.
A=Active ChartField
I=Inactive ChartField
3 AFFILIATE_TYPE Character(1) VARCHAR2(1) NOT NULL Tells if the Chartfield is Intra Unit Affiliate or Inter Unit Affiliate.
A=IntraUnit Affiliate
I=InterUnit Affiliate
X=Standard
4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
5 ORIG_REC_NAME Character(15) VARCHAR2(15) NOT NULL Original Record Name
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
8 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
9 NEW_CF_LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
10 NEW_CF_SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
11 CF_ORDER Number(2,0) SMALLINT NOT NULL ChartField Sequence Order
12 PREV_CF_ORDER Number(2,0) SMALLINT NOT NULL Previous ChartField Sequence Order
13 DISPLAY_LENGTH Number(2,0) SMALLINT NOT NULL Use to determine the ChartField Length to be display.
14 NEW_DISP_LENGTH Number(2,0) SMALLINT NOT NULL New Display Length
15 AFF_RELATED_CF Character(18) VARCHAR2(18) NOT NULL Holds the Related Chartfield that is needed by Affiliate Chartfield.
16 NEW_RELATED_CF Character(18) VARCHAR2(18) NOT NULL Holds the previous Affiliate Related Chartfield if the Affiliate Related Chartfield changes.