BI_LN_PC_EC_VW(SQL View) |
Index Back |
|---|---|
Bill Line Project Data View |
| SELECT BUSINESS_UNIT , INVOICE , LINE_SEQ_NUM , BUSINESS_UNIT_PC , PROJECT_ID , ANALYSIS_TYPE , RESOURCE_TYPE , RESOURCE_CATEGORY , RESOURCE_SUB_CAT , ACTIVITY_ID , ACTIVITY_TYPE , SYSTEM_SOURCE , EMPLID , SSN , EMPL_RCD FROM PS_BI_LINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | LINE_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Sequence |
| 4 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Default Value: BI_HDR.BUSINESS_UNIT_PC |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: BI_HDR.PROJECT_ID |
| 6 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Default Value: BI_HDR.ANALYSIS_TYPE |
| 7 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Default Value: BI_HDR.RESOURCE_TYPE |
| 8 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Default Value: BI_HDR.RESOURCE_CATEGORY |
| 9 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Default Value: BI_HDR.RESOURCE_SUB_CAT |
| 10 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Default Value: BI_HDR.ACTIVITY_ID |
| 11 | ACTIVITY_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason Default Value: BI_HDR.ACTIVITY_TYPE |
| 12 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
Default Value: BI_HDR.SYSTEM_SOURCE |
| 13 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 14 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 15 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |