RUN_GM_FA_AE(SQL Table) |
Index Back |
|---|---|
Grants F&A Process 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_NBR |
Number(4,0) | SMALLINT NOT NULL |
Request Number
Default Value: 1 |
| 4 | BUPRJACT_OPTION |
Character(1) | VARCHAR2(1) NOT NULL |
BU/Proj/Act Option
A=Selected BU / Proj / Activity B=Selected Business Unit E=All P=Selected BU / Project |
| 5 | DATE_RANGE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date E=All T=Transaction Date Default Value: E |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 7 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
| 8 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_VW |
| 9 | FROM_DATE | Date(10) | DATE | From Date |
| 10 | THRU_DATE | Date(10) | DATE | Through Date |
| 11 | EXCEPT_ACCT_DT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Exception Accounting Date
Y/N Table Edit Default Value: N |
| 12 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 13 | RUN_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Program Run Code
1=Load ASSETGEN.ASC File 2=Load BOOKDATA.ASC File 3=Load LABLINFO.ASC File 4=Load PROPTMGR.ASC File N=None PRE=Preview Process PRO=Procedural RUN=Run Process SET=Set Process |