AM_IMP_RPT_RUN

(SQL Table)
Index Back

Impair Report Run Control

# 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 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

Default Value: 1

4 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

5 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success

Default Value: N

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_IMP_BU_NONVW

7 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

Prompt Table: SP_IMP_BK_NONVW

8 IMPAIR_STRATEGY Character(1) VARCHAR2(1) NOT NULL Impairment Strategy
A=Impair by Assets
C=Impair by CGU

Default Value: A

9 CGU_ID Character(20) VARCHAR2(20) NOT NULL Cash Generating Unit

Prompt Table: AM_CGU_HDR

10 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

Prompt Table: CATEGORY_TBL

11 IMPAIR_DT_FROM Date(10) DATE NOT NULL Impairment Date From
12 IMPAIR_DT_TO Date(10) DATE NOT NULL Impairment Date To
13 AS_OF_DATE Date(10) DATE As of Date

Default Value: %date

14 REPORT_REQST_GB Character(1) VARCHAR2(1) NOT NULL Report Request Parameters