MASSCHNGE_RQST

(SQL Table)
Index Back

Request for program AMDPREPT

# 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

Prompt Table: SP_BU_AM_NONVW

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

Prompt Table: BU_BOOK_VW2

8 FROM_ASSET_ID Character(12) VARCHAR2(12) NOT NULL From Asset ID

Prompt Table: %EDIT_ASSET_ID

9 TO_ASSET_ID Character(12) VARCHAR2(12) NOT NULL To Asset ID

Prompt Table: %EDIT_ASSET_ID

10 TRANS_DT Date(10) DATE Transaction Date
11 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
12 ACTION Character(3) VARCHAR2(3) NOT NULL Action
13 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
14 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
15 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
16 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
17 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
18 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
19 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
20 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
21 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
22 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
23 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
24 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
25 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
26 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
27 ADJUST_PCT_POP Signed Number(8,3) DECIMAL(6,3) NOT NULL Percent
28 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost