HCSC_TRNSLT_AET

(SQL Table)
Index Back

Translation Utility State Rec

Internal use only. Thisis a state record for the Translation Utility AE (HCSC_TRANSLAT)

# 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 HCSC_CNT1 Number(8,0) INTEGER NOT NULL For internal use only. Used in HCSC_TRANSLT_AET record for translation utility.
5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
6 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
7 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID
8 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
9 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
10 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
11 FIELDUSE Number(10,0) DECIMAL(10) NOT NULL Panel Field Use
12 INPUT_PROJECT Character(30) VARCHAR2(30) NOT NULL Internal Use only. Field is used on HCSC_TRANSLATE_RC (Translation Utility) run control page.
13 OUTPUT_PROJECT Character(30) VARCHAR2(30) NOT NULL Internal Use only. Field is used on HCSC_TRANSLATE_RC (Translation Utility) run control page.
14 HCSC_LABEL_ID Character(18) VARCHAR2(18) NOT NULL For internal use only. Used in HCSC_TRANSLT_AET record for translation utility.
15 SQL_STMT Long Character(8048) CLOB SQL Statement
16 HCSC_SQL_TEXT Character(254) VARCHAR2(254) NOT NULL Internal Use only. Used in as SQL Text for AET rec HCSC_TRNSLT_AET