GM_PT_EFFT_AET

(SQL Table)
Index Back

Effort staging cache record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
3 FILENAME_ERR Character(1) VARCHAR2(1) NOT NULL Filename Error
4 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_SUPPLIER_EC
06=ITM_SUPP_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
13=EN_REVISION_EC
14=ITEM_MFG_GPO_EC
15=ITEM_MFG_EC
16=ITEM_CAT_EC
5 RECORDNAME2 Character(15) VARCHAR2(15) NOT NULL Record Name 2
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
8 FA_CS_FROM_VALUE Character(10) VARCHAR2(10) NOT NULL Chartfield From Value
9 FA_CS_TO_VALUE Character(10) VARCHAR2(10) NOT NULL Chartfield To Value
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 FIELDNAME_ALIAS Character(30) VARCHAR2(30) NOT NULL Field Name Alias
12 SETID_FLAG Character(1) VARCHAR2(1) NOT NULL SetID Flag
N=Setid in Value
X=No Setid
Y=Setid in Field
13 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
14 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
15 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter
16 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause