PAY_CONFIG_AET

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 CF_PROCESS_MODE Character(1) VARCHAR2(1) NOT NULL ChartField Configuration Processing Mode
R=Report Mode
U=Update Mode
5 ORIG_CF_NAME Character(18) VARCHAR2(18) NOT NULL Holds the Original Chartfield Name. This will not change!
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
8 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
9 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
10 PREV_LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
11 PREV_SHORTNAME Character(15) VARCHAR2(15) NOT NULL Prev Short Name
12 HP_FIELD_DESCR Character(30) VARCHAR2(30) NOT NULL Field Description for use by Retro Distribution query
13 PREV_RELATED_CF Character(18) VARCHAR2(18) NOT NULL Holds the previous Affiliate Related Chartfield if the Affiliate Related Chartfield changes.
14 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
15 DISPLAY_LENGTH Number(2,0) SMALLINT NOT NULL Use to determine the ChartField Length to be display.
16 CF_ORDER Number(2,0) SMALLINT NOT NULL ChartField Sequence Order
17 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
18 CF_LENGTH Number(2,0) SMALLINT NOT NULL ChartField Length
19 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code