CNAO_XML_SUBPRC

(SQL Table)
Index Back

XML Generation Subprocess Rec

The record serves to store parameters for XML file generation sub processes and hold history of sub processes.

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
5 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
6 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 PROCESS_MODULE Character(12) VARCHAR2(12) NOT NULL Process Module
9 PERIOD_FROM Number(3,0) SMALLINT NOT NULL From Period
10 PERIOD_TO Number(3,0) SMALLINT NOT NULL To Period
11 PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL Process Name
12 PROCESS_INSTANCE2 Number(10,0) DECIMAL(10) NOT NULL Process Instance
13 MODULE_PRCS_STATUS Character(1) VARCHAR2(1) NOT NULL Status
F=Failed
P=Processing
Q=Queued
S=Success
14 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
15 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
16 HCM_FILE Character(254) VARCHAR2(254) NOT NULL HCM File