PGM_MRS_HGRID(SQL Table) |
Index Back |
|---|---|
Master Resource Schedule HGridStores information of Master Resource Schedule HGrid. |
| # | 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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 5 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 6 | TEAM_MEMBER |
Character(30) | VARCHAR2(30) NOT NULL | Team Member |
| 7 | DT_OF_WEEK |
Date(10) | DATE | Date of week |
| 8 | DESCR80 |
Character(80) | VARCHAR2(80) NOT NULL | Description |
| 9 | OVERLOAD_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL | Overload Indicator |
| 10 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 11 | PLAN_PROJROLE | Character(15) | VARCHAR2(15) NOT NULL | Requirement Project Role |
| 12 | ASSGND_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Assigned Work |
| 13 | MONHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Monday Hours |
| 14 | TUEHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Tuesday Hours |
| 15 | WEDHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Wednesday Hours |
| 16 | THRHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Thursday Hours |
| 17 | FRIHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Friday Hours |
| 18 | SATHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | saturday Hours |
| 19 | SUNHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Sunday Hours |
| 20 | WEEK | Number(2,0) | SMALLINT NOT NULL | Week |
| 21 | WEEK1 | Number(15,2) | DECIMAL(14,2) NOT NULL | Week 1 |
| 22 | WEEK2 | Number(15,2) | DECIMAL(14,2) NOT NULL | Week 2 |
| 23 | WEEK3 | Number(15,2) | DECIMAL(14,2) NOT NULL | Week 3 |
| 24 | WEEK4 | Number(15,2) | DECIMAL(14,2) NOT NULL | Week 4 |
| 25 | WEEK5 | Number(15,2) | DECIMAL(14,2) NOT NULL | Week 5 |
| 26 | MONTH_VALUE | Number(2,0) | SMALLINT NOT NULL | Month |
| 27 | JANHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | January |
| 28 | FEBHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | February |
| 29 | MARHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | March |
| 30 | APRHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | April |
| 31 | MAYHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | May |
| 32 | JUNHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | June |
| 33 | JULHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | July |
| 34 | AUGHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | August |
| 35 | SEPHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | September |
| 36 | OCTHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | October |
| 37 | NOVHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | November |
| 38 | DECHRS | Number(15,2) | DECIMAL(14,2) NOT NULL | December |
| 39 | OVERLOAD_DATE | Date(10) | DATE | Overload Date |
| 40 | LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Level |
| 41 | LEVEL1 | Number(5,0) | INTEGER NOT NULL | Level 1 |
| 42 | LEVEL2 | Number(5,0) | INTEGER NOT NULL | Level 2 |
| 43 | LEVEL3 | Number(5,0) | INTEGER NOT NULL | Level 3 |
| 44 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 45 | EXPAND_COLL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Expand Row |
| 46 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 47 | 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 |
| 48 | ACT_RES_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Activity Resource
N=No Y=Yes |
| 49 | RUNDTTM | DateTime(26) | TIMESTAMP | Run Date/Time |