PROCESS_INSTANCEB=Budget Calendar
D=Detail Calendar
I=Summary Budget Period Calendar
P=Budget Period Calendar
S=Summary Calendar
T=Promo Mgmt Sales Calendar
Default Value: N
Y/N Table Edit
Y/N Table Edit
D_DAY_CORE_AET(SQL Table) |
Index Back |
|---|---|
Generic AE Run tableThis record contains the set of required AE cache fields. It does not include fields required by a specific engine; just the general purpose fields used across all jobs. PF_TBLSUITE PF_TREETBL PF_RESOLVER Metadata etc. |
| # | 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 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | PF_SCENARIO_ID | Character(10) | VARCHAR2(10) NOT NULL | Defines process as HISTORICAL/FORECAST and identifies the model_id for the analytical engines. |
| 7 | PF_SCENARIO_TYPE | Character(1) | VARCHAR2(1) NOT NULL | This Determines whther the scenario will be used for histrical or forcasting purposes. |
| 8 | PF_SCEN_INPUT_ID | Character(10) | VARCHAR2(10) NOT NULL | Input Scenario ID: This is used in the scenario definition to specify the source scenario id. This is used by resolver to select data from a scenario keyed table. |
| 9 | MODEL_ID | Character(5) | VARCHAR2(5) NOT NULL | Model ID |
| 10 | PF_LEDGER_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Ledger Flag indicating the a Ledger Association |
| 11 | PF_LED_ID | Character(10) | VARCHAR2(10) NOT NULL | uniquely identifies the ledger. |
| 12 | LEDGER_TEMPLATE | Character(10) | VARCHAR2(10) NOT NULL | Ledger Template |
| 13 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 14 | 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. |
| 15 | ASOF_DT | Date(10) | DATE | As of Date |
| 16 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 17 | END_DT | Date(10) | DATE | End Date |
| 18 | JOB_ID | Character(10) | VARCHAR2(10) NOT NULL | Job ID |
| 19 | JOBSTREAM_SEQ | Number(5,0) | INTEGER NOT NULL | Jobstream Sequence |
| 20 | ENGINE_ID | Character(10) | VARCHAR2(10) NOT NULL | What is the engine that will be run |
| 21 | ENGINE_GROUP | Character(3) | VARCHAR2(3) NOT NULL | This field contain the grouping value for Application Engines. On the Engine Metadata panel, if the AE being defined requires a Model Id to process, it must be assigned an Engine Group. The translate values correspond to the fields in the Scenario child table. |
| 22 | RECSUITE_ASSIGNED | Character(1) | VARCHAR2(1) NOT NULL | Record Suite Assigned |
| 23 | RECSUITE_ID | Character(10) | VARCHAR2(10) NOT NULL | Record Suite ID |
| 24 | JOBSTREAM_ID | Character(10) | VARCHAR2(10) NOT NULL | Job Stream ID |
| 25 | TABLE_APPEND | Character(2) | VARCHAR2(2) NOT NULL | Table Append |
| 26 | DIM_TABLE_APPEND | Character(2) | VARCHAR2(2) NOT NULL | Dimension Table Append |
| 27 | FACT_TABLE_APPEND | Character(2) | VARCHAR2(2) NOT NULL | Fact Table Append |
| 28 | PARENT_TBL_APPEND | Character(2) | VARCHAR2(2) NOT NULL | Parent Table Append |
| 29 | PARENT_PRCS_INS | Number(10,0) | DECIMAL(10) NOT NULL | Spawner (Parent) Process Instance |
| 30 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 31 | SETID_TREE | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 32 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 33 | CALENDAR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Calendar
B=Budget Calendar D=Detail Calendar I=Summary Budget Period Calendar P=Budget Period Calendar S=Summary Calendar T=Promo Mgmt Sales Calendar |
| 34 | NUMBER_OF_PERIODS | Number(3,0) | SMALLINT NOT NULL | Periods in a Year |
| 35 | IF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | If Flag Dummy |
| 36 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 37 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 38 | PF_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Table Name |
| 39 | PF_RECNAME_STUB | Character(13) | VARCHAR2(13) NOT NULL | Record Stub |
| 40 | CHILD_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Child Record Name |
| 41 | PF_CHILD_STUB | Character(13) | VARCHAR2(13) NOT NULL | Record Stub |
| 42 | PF_SQL_OBJ_ID_PRFX | Character(30) | VARCHAR2(30) NOT NULL | SQL Object ID Prefix |
| 43 | PF_SQL_OBJ_MR_PRFX | Character(30) | VARCHAR2(30) NOT NULL | SQL Object ID Prefix MetaRecs |
| 44 | PF_SQL_OBJ_RL_PRFX | Character(30) | VARCHAR2(30) NOT NULL | SQL Object ID Prefix MetaRules |
| 45 | RECNAME_PRIMARY | Character(15) | VARCHAR2(15) NOT NULL | Primary Record |
| 46 | CURRENT_MODEL | Character(5) | VARCHAR2(5) NOT NULL | Current Model Id |
| 47 | PROCESS_MODEL_ID | Character(5) | VARCHAR2(5) NOT NULL | Model Id |
| 48 | RESOLVED_MODELS | Character(100) | VARCHAR2(100) NOT NULL | Resolved Models List |
| 49 | PF_TEMP_FIELD | Character(30) | VARCHAR2(30) NOT NULL | Temp field for use by AE |
| 50 | PF_TREE_ID | Character(20) | VARCHAR2(20) NOT NULL | Tree ID defined in Tree MetaData |
| 51 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 52 | TREE_FLAT_TBL_NAME | Character(20) | VARCHAR2(20) NOT NULL | Tree Table Name |
| 53 | TREE_FLAT_STUB | Character(13) | VARCHAR2(13) NOT NULL | Tree Table Stub Name |
| 54 | TREE_LEAF_TBL_NAME | Character(20) | VARCHAR2(20) NOT NULL | Temp Tree Flat Table |
| 55 | TREE_NODE_TBL_NAME | Character(20) | VARCHAR2(20) NOT NULL | Temp Tree Flat Table |
| 56 | RERUN_OPTION | Character(1) | VARCHAR2(1) NOT NULL | Rerun Option |
| 57 | PF_ERROR_CODE | Number(5,0) | INTEGER NOT NULL | Error Code |
| 58 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 59 | PF_ASOF_DT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Determines whether this job / jobstream is ASOF_DTed or not. If the value is 'Y' - it is, if the value is 'N' - it is not (FY/AP). |
| 60 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 61 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 62 | STATE_RECORD | Character(15) | VARCHAR2(15) NOT NULL | State Record |
| 63 | EFFDT_ADJ | Signed Number(4,0) | DECIMAL(3) NOT NULL | Effective Date Adjustment |
| 64 | UOM | Character(2) | VARCHAR2(2) NOT NULL | Unit of Measure |
| 65 | PROCESS_BATCH_ID | Character(1) | VARCHAR2(1) NOT NULL | Process Batch ID |
| 66 | PF_BATCH_ID | Character(15) | VARCHAR2(15) NOT NULL | PF Batch ID |
| 67 | BATCH_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Batch Status |
| 68 | POST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Post Flag |
| 69 | PF_BATCH_NUM | Number(6,0) | INTEGER NOT NULL | Last Batch Number |
| 70 | PROCESS_BALANCE | Character(1) | VARCHAR2(1) NOT NULL | Process Balance |
| 71 | MANUAL_RECON_PROC | Character(1) | VARCHAR2(1) NOT NULL | Manual Recon Process |
| 72 | PROCESS_EDIT | Character(1) | VARCHAR2(1) NOT NULL | Run Edit for Profit Manager |
| 73 | CONSOL_BATCH | Character(1) | VARCHAR2(1) NOT NULL | Consolidation Batch |
| 74 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 75 | PF_MC_RULESET_ID | Character(10) | VARCHAR2(10) NOT NULL | Currency Rule Set |
| 76 | BU_CONSOLIDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Consolidated |
| 77 | SC_CONSOLIDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Consolidated |
| 78 | PF_SELECT_WHERE | Character(1) | VARCHAR2(1) NOT NULL | Used within AE PF_MERGE to determine which Delete to use for Merging temp tables back into perm tables to avoid dups. |
| 79 | PF_SELECT_MERGE | Character(1) | VARCHAR2(1) NOT NULL | Flag used on Record Metadata to determine if a Record will be used with a Selective Where Clause within the Merge AE. |
| 80 | EPM_NO_LIST_EDITS | Character(1) | VARCHAR2(1) NOT NULL | EPM No List Edits |
| 81 | PF_REC_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Table type |
| 82 | PF_SEND_EMAIL | Character(1) | VARCHAR2(1) NOT NULL | Determines if an email should be sent to all the listed recipients with the specified Subject message. |
| 83 | PF_EMAIL_ADDR | Character(254) | VARCHAR2(254) NOT NULL | Email Address |
| 84 | PF_EMAIL_CC | Character(254) | VARCHAR2(254) NOT NULL | Email CC |
| 85 | PF_EMAIL_BCC | Character(254) | VARCHAR2(254) NOT NULL | Email BCC |
| 86 | PF_EMAIL_SUBJ | Character(254) | VARCHAR2(254) NOT NULL | Stores email subjects. |
| 87 | PF_EMAIL_TEXT | Long Character | CLOB | Stores email text. |
| 88 | PF_SEVERITY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Severity |
| 89 | PF_RECSUITE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Recsuite set flag |
| 90 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
| 91 | PF_CHUNK_CODE | Character(20) | VARCHAR2(20) NOT NULL | Chunk Code is the key that identifies the chunk |
| 92 | PF_SPAWN_ID | Character(20) | VARCHAR2(20) NOT NULL | Spawn ID |
| 93 | PF_SET_PARMRG_FLG | Character(1) | VARCHAR2(1) NOT NULL | Set Parent Merge Flags |
| 94 | MDW_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
MDW Flag
Default Value: N |
| 95 | RETRY_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Flag that specifies whether or not to retry
Y/N Table Edit |
| 96 | UNLIMITED_RETRIES | Character(1) | VARCHAR2(1) NOT NULL |
Flag that specifies whether to retry an unlimited number of times.
Y/N Table Edit |
| 97 | RETRY_COUNT | Signed Number(11,0) | DECIMAL(10) NOT NULL | Specifies the number of retry attempts in jobstreams. |
| 98 | RETRY_INTERVAL | Number(5,0) | INTEGER NOT NULL | Indicates the Time to wait when resources are not available |
| 99 | AE_APPSTATUS | Number(1,0) | SMALLINT NOT NULL | AE Application Warning Status |
| 100 | SCENARIO_SID | Number(10,0) | DECIMAL(10) NOT NULL | Scenario surrogate key (E) |
| 101 | SCENARIO_IN_SID | Number(10,0) | DECIMAL(10) NOT NULL | SCENARIO_SID |
| 102 | DT_PATTERN_SID | Number(10,0) | DECIMAL(10) NOT NULL | This is the surrogate ID for calendar pattern. |
| 103 | SRC_SYS_ID | Character(5) | VARCHAR2(5) NOT NULL | Warehouse is populated from one or more source systems. This field is used to indicate the source system from which the row was copied into the warehouse table. The values for Source System ID are custom defined. |
| 104 | PBU_SID | Number(10,0) | DECIMAL(10) NOT NULL | Performance BU Surrogate ID |
| 105 | PF_COMPONENT | Character(4) | VARCHAR2(4) NOT NULL | Component Values are 1000 Operational Data Store 2000 Data Warehouse 3000 Data Mart Used in record Metadata |
| 106 | DETAIL_CALENDAR | Character(2) | VARCHAR2(2) NOT NULL | Detail Calendar |
| 107 | BEGINDTTM | DateTime(26) | TIMESTAMP | Begin Date/Time |
| 108 | ENDDTTM | DateTime(26) | TIMESTAMP | End Date/Time |