BUSINESS_UNITPROPOSAL_IDVERSION_IDSUB_PROP_NBRTEAM_MEMBER_CLASSA=Asset
L=Labor
M=Material
O=Other
TEAM_MEMBERGM_PM_PRJ_TM_DT(SQL View) |
Index Back |
|---|---|
Team Members under Prop Proj |
| SELECT A.BUSINESS_UNIT ,A.PROPOSAL_ID ,A.VERSION_ID ,A.SUB_PROP_NBR ,A.TEAM_MEMBER_CLASS ,A.TEAM_MEMBER ,A.BUDGET_ID ,A.BUDGET_PERIOD_GM ,A.BUDGET_LN ,A.SEQ_NUM ,A.BEGIN_DT ,A.END_DT FROM PS_GM_OPPTY_DTL_TM A WHERE A.TEAM_MEMBER_CLASS = 'L' AND A.TEAM_MEMBER <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 4 | SUB_PROP_NBR |
Character(15) | VARCHAR2(15) NOT NULL | SUB_PROP_NBR |
| 5 | TEAM_MEMBER_CLASS |
Character(1) | VARCHAR2(1) NOT NULL |
05/26/2004 - FS
Translate Value "O" added.
A=Asset L=Labor M=Material O=Other |
| 6 | TEAM_MEMBER |
Character(30) | VARCHAR2(30) NOT NULL | Team Member |
| 7 | BUDGET_ID | Character(15) | VARCHAR2(15) NOT NULL | BUDGET_ID |
| 8 | BUDGET_PERIOD_GM | Number(3,0) | SMALLINT NOT NULL | BUDGET_PERIOD_GM |
| 9 | BUDGET_LN | Number(6,0) | INTEGER NOT NULL | BUDGET_LN |
| 10 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 11 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 12 | END_DT | Date(10) | DATE | End Date |