SPF_REQ_LN_EM_V (SQL View)	Index Back
SP Requisition Line View A view of the entire SPF_REQ_LINE record. This view contains no where clauses so it could be reused by appending the appropriate filter(s). SELECT A.BUSINESS_UNIT , A.SP_REQ_ID , A.LINE_NBR , A.SP_REQ_STATUS , A.HOLD_STATUS , A.IN_PROCESS_FLG , A.BUSINESS_UNIT_PC , A.PROJECT_ID , A.DESCR , A.DEPTID , A.SP_DURATION , A.START_DATE , A.END_DATE , A.TELECOMMUTE , A.SPF_RATE , A.SP_RATE_UOM , A.UNIT_OF_MEASURE , A.JOB_TITLE , A.ROLE_TYPE , A.PROJ_ROLE , A.LOCATION , A.EDUCATION_LVL , A.SPF_YRS_EXPERIENCE , A.COMPETENCY_DESC , A.INTERVIEWREQUIRED , A.TRAVEL_REQUIRED , A.TRAVEL_FREQUENCY , A.CONTRACT_FOR_HIRE , A.CURRENCY_CD , A.OPRID_APPROVED_BY , A.APPROVAL_DT , A.REQUESTOR_ID , A.RECRUITER , A.TE_APPROVER , A.SPF_SPLR_RATE , A.SP_SPLR_RATE_UOM , A.CURRENCY_CD_SPLR , A.SPF_REQ_LN_TOTAL , A.EXPENSES_INCLUDED , A.OVERTIME_PERMITTED , A.SPF_EXTERNAL , A.SPF_CUST_COMPANY , A.COMMENTS_254 , A.ROW_CREATE_DATE , A.ROW_MODIFY_DATE , A.ROW_CREATE_USER , A.ROW_MODIFY_USER , B.SPF_JOB_DESCRLONG FROM PS_SPF_REQ_LINE A , PS_SPF_REQ_LINE_JD B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SP_REQ_ID = B.SP_REQ_ID AND A.LINE_NBR = B.LINE_NBR

SPF_REQ_LN_EM_V

(SQL View)

SP Requisition Line View

A view of the entire SPF_REQ_LINE record. This view contains no where clauses so it could be reused by appending the appropriate filter(s). SELECT A.BUSINESS_UNIT , A.SP_REQ_ID , A.LINE_NBR , A.SP_REQ_STATUS , A.HOLD_STATUS , A.IN_PROCESS_FLG , A.BUSINESS_UNIT_PC , A.PROJECT_ID , A.DESCR , A.DEPTID , A.SP_DURATION , A.START_DATE , A.END_DATE , A.TELECOMMUTE , A.SPF_RATE , A.SP_RATE_UOM , A.UNIT_OF_MEASURE , A.JOB_TITLE , A.ROLE_TYPE , A.PROJ_ROLE , A.LOCATION , A.EDUCATION_LVL , A.SPF_YRS_EXPERIENCE , A.COMPETENCY_DESC , A.INTERVIEWREQUIRED , A.TRAVEL_REQUIRED , A.TRAVEL_FREQUENCY , A.CONTRACT_FOR_HIRE , A.CURRENCY_CD , A.OPRID_APPROVED_BY , A.APPROVAL_DT , A.REQUESTOR_ID , A.RECRUITER , A.TE_APPROVER , A.SPF_SPLR_RATE , A.SP_SPLR_RATE_UOM , A.CURRENCY_CD_SPLR , A.SPF_REQ_LN_TOTAL , A.EXPENSES_INCLUDED , A.OVERTIME_PERMITTED , A.SPF_EXTERNAL , A.SPF_CUST_COMPANY , A.COMMENTS_254 , A.ROW_CREATE_DATE , A.ROW_MODIFY_DATE , A.ROW_CREATE_USER , A.ROW_MODIFY_USER , B.SPF_JOB_DESCRLONG FROM PS_SPF_REQ_LINE A , PS_SPF_REQ_LINE_JD B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SP_REQ_ID = B.SP_REQ_ID AND A.LINE_NBR = B.LINE_NBR

SELECT A.BUSINESS_UNIT , A.SP_REQ_ID , A.LINE_NBR , B.REQ_ID , A.ENGAGEMENT_MNGR , A.SP_REQ_STATUS , A.START_DATE , A.END_DATE , A.ROLE_TYPE , A.PROJ_ROLE , A.SERVICE_METHOD , A.SP_NUM_OF_POSITION FROM PS_SPF_REQ_LINE A , PS_PV_REQ_LN_XREF B WHERE A.BUSINESS_UNIT = B.SP_BUSINESS_UNIT AND A.SP_REQ_ID = B.SP_REQ_ID AND A.LINE_NBR = B.LINE_NBR

Parent record: SPF_REQ_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PM_NONVW

2 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
Default Value: NEXT

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
Default Value: 1

4 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

5 ENGAGEMENT_MNGR Character(30) VARCHAR2(30) NOT NULL Engagement Manager

6 SP_REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Requisition Status for Service Procurement
A=Approved
C=Complete
D=Denied
F=Filled
O=Open
P=Pending
R=On Hold
S=Sourced
X=Canceled

7 START_DATE Date(10) DATE Start Date for Gen Standing PO

8 END_DATE Date(10) DATE End Date

9 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator

10 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

11 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource
Default Value: R

12 SP_NUM_OF_POSITION Number(5,0) INTEGER NOT NULL Number of Positions
Default Value: 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PM_NONVW
2	SP_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Request ID Default Value: NEXT
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
4	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
5	ENGAGEMENT_MNGR	Character(30)	VARCHAR2(30) NOT NULL	Engagement Manager
6	SP_REQ_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Requisition Status for Service Procurement A=Approved C=Complete D=Denied F=Filled O=Open P=Pending R=On Hold S=Sourced X=Canceled
7	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
8	END_DATE	Date(10)	DATE	End Date
9	ROLE_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Service Type APR=Approver MGR=Manager OPR=Operator
10	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role
11	SERVICE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Service Method D=Deliverable M=Multi Resource R=Resource Default Value: R
12	SP_NUM_OF_POSITION	Number(5,0)	INTEGER NOT NULL	Number of Positions Default Value: 1