BUSINESS_UNITPROPOSAL_IDVERSION_IDSUB_PROP_NBRBUDGET_IDBUDGET_PERIOD_GM1=Mr.
2=Mrs.
3=Ms.
GM_EC_BUD_PERS(SQL View) |
Index Back |
|---|---|
EDI BUDGET PERSONNEL DETAIL |
| SELECT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , A.SUB_PROP_NBR , A.BUDGET_ID , A.BUDGET_PERIOD_GM , A.BUDGET_LN , A.ROW_NUMBER , A.NAME , A.PROJECT_ROLE , A.APPT_TYPE_CALENDAR , A.APPT_TYPE_ACADEMIC , A.APPT_TYPE_SUMMER , %Abs(%Round(%DecDiv(A.DAYS_ELAPSED,30) ,0) ) , CASE A.APPT_TYPE_CALENDAR WHEN 'Y' THEN %Abs(%Round(%DecDiv(A.DAYS_ELAPSED,30) ,0) ) ELSE 0 END , CASE A.APPT_TYPE_ACADEMIC WHEN 'Y' THEN %Abs(%Round(%DecDiv(A.DAYS_ELAPSED,30) ,0) ) ELSE 0 END , CASE A.APPT_TYPE_SUMMER WHEN 'Y' THEN %Abs(%Round(%DecDiv(A.DAYS_ELAPSED,30) ,0) ) ELSE 0 END , %Abs(%Round(%DecMult(%DecDiv(A.DAYS_ELAPSED,30) , %DecDiv(A.PERCENTAGE,100)) ,0) ) , A.PERCENTAGE , A.ANNUAL_SALARY_GM , A.SPONSOR_SALARY_AMT , A.SPONSOR_FRINGE_AMT , A.SPONSOR_AMT , A.BUDGET_AMT , A.BEGIN_DT , A.END_DT , A.NAME_PREFIX , A.NAME_SUFFIX , A.FIRST_NAME , A.LAST_NAME , A.MIDDLE_NAME , A.EMPLID , A.PROF_ROLE_TYPE FROM PS_GM_BUD_PDTL_VW9 A |
| # | 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 | BUDGET_ID |
Character(15) | VARCHAR2(15) NOT NULL | BUDGET_ID |
| 6 | BUDGET_PERIOD_GM |
Number(3,0) | SMALLINT NOT NULL | BUDGET_PERIOD_GM |
| 7 | BUDGET_LN | Number(6,0) | INTEGER NOT NULL | BUDGET_LN |
| 8 | ROW_NUMBER | Number(3,0) | SMALLINT NOT NULL | Row_Number |
| 9 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 10 | PROJECT_ROLE | Character(30) | VARCHAR2(30) NOT NULL | Project Role |
| 11 | APPT_TYPE_CALENDAR | Character(1) | VARCHAR2(1) NOT NULL | APPT_TYPE_CALENDAR |
| 12 | APPT_TYPE_ACADEMIC | Character(1) | VARCHAR2(1) NOT NULL | APPT_TYPE_ACADEMIC |
| 13 | APPT_TYPE_SUMMER | Character(1) | VARCHAR2(1) NOT NULL | APPT_TYPE_SUMMER |
| 14 | APPT_TYPE_MONTHS | Number(3,0) | SMALLINT NOT NULL | Months for Appointment Type |
| 15 | CA_PERSON_MONTHS | Number(3,0) | SMALLINT NOT NULL | Person Months |
| 16 | AC_PERSON_MONTHS | Number(3,0) | SMALLINT NOT NULL | Person Months |
| 17 | SU_PERSON_MONTHS | Number(3,0) | SMALLINT NOT NULL | Person Months |
| 18 | PERSON_MONTHS | Number(3,0) | SMALLINT NOT NULL | Person Months |
| 19 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 20 | ANNUAL_SALARY_GM | Number(27,3) | DECIMAL(26,3) NOT NULL | NNUAL_SALARY_GM |
| 21 | BUDGET_SALARY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | BUDGET_SALARY |
| 22 | FRINGE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | FRINGE_AMT |
| 23 | BUDGET_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | BUDGET_AMT |
| 24 | FED_NON_FED | Number(27,3) | DECIMAL(26,3) NOT NULL | Total |
| 25 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 26 | END_DT | Date(10) | DATE | End Date |
| 27 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
1=Mr. 2=Mrs. 3=Ms. |
| 28 | NAME_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Suffix |
| 29 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 30 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 31 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 32 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 33 | PROF_ROLE_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Role Type |