PO_RPTCF

(SQL Table)
Index Back

Report Chartfields

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
5 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
6 CF_SELECT_OPT Character(1) VARCHAR2(1) NOT NULL Include ChartField Values

Y/N Table Edit

Default Value: Y

7 CF_SUB_TOTAL_OPT Character(1) VARCHAR2(1) NOT NULL Subtotal by ChartField

Y/N Table Edit

Default Value: N

8 CF_SHOW_DESCR_OPT Character(1) VARCHAR2(1) NOT NULL Show Description Option

Y/N Table Edit

Default Value: N

9 CHARTFIELD_VALUE Character(30) VARCHAR2(30) NOT NULL ChartField Value

Prompt Table: %EDITTABLE

10 PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Prompt Table
11 CF_VALUE_TO Character(30) VARCHAR2(30) NOT NULL CF_VALUE_TO

Prompt Table: %EDITTABLE