BUSINESS_UNITVENDOR_IDFO_SHIP_TO_CUST_IDE=Employee
N=Non-Employee
A=Assign
C=Complete
I=Interview
P=Propose
R=Reject
S=Reserve
V=Pending Approval
X=Cancel
FO_ASGMNT_RT_VW(SQL View) |
Index Back |
|---|---|
Assignment Rate ViewAssignment Rate View |
| SELECT FASG.BUSINESS_UNIT , FASG.VENDOR_ID , FORD.CUST_ID , FORD.OWNERSHIP_ID , FASG.SO_ID , FASG.ASSIGNMENT_ID , FASG.SO_LINE , PD.PER_STATUS , FSTS.ASSIGN_STS , FORD.PROJECT_ID , FASG.ACTIVITY_ID , FASG.EMPLID , FASG.DESCR , FASG.JOBCODE , FDT.START_DT , FDT.END_DT , FRT.REG_PAY_RATE , PRT.RATE_AMT , FRE.CURRENCY_CD FROM PS_RS_ASSIGNMENT FASG , PS_FO_ASGN_RT_DTL FRT , PS_RS_SO_HDR FORD , PS_PERSONAL_DATA PD , PS_PROJ_ACT_TEAM PT , PS_FO_RATE_ELEMENT FRE , PS_SET_CNTRL_REC SCR , PS_FO_ASGN_DATE_VW FDT , PS_RS_ASSGN_STS FSTS , PS_CA_RATE CRT , PS_PC_RATE_DTL_LN PRT WHERE FORD.SO_ID = FASG.SO_ID AND FORD.BUSINESS_UNIT = FASG.BUSINESS_UNIT AND FORD.CONTRACT_NUM = CRT.CONTRACT_NUM AND FASG.CONTRACT_LINE_NUM = CRT.CONTRACT_LINE_NUM AND %EffdtCheck(CA_RATE CRT2, CRT, %CurrentDateIn) AND CRT.PC_TEMPLATE_ID = PRT.PC_TEMPLATE_ID AND PRT.TEMPLATE_TYPE = 'C' AND PRT.BUSINESS_UNIT = FASG.BUSINESS_UNIT AND %EffdtCheck(PC_RATE_DTL_LN PRT2, PRT, %CurrentDateIn) AND FASG.ASSIGNMENT_ID = FRT.ASSIGNMENT_ID AND %EffdtCheck(FO_ASGN_RT_DTL FRT2, FRT, %CurrentDateIn) AND FRT.DETAIL_NO = PRT.DETAIL_NO AND PD.EMPLID = FASG.EMPLID AND PT.BUSINESS_UNIT = FASG.BUSINESS_UNIT AND PT.PROJECT_ID = FORD.PROJECT_ID AND PT.ACTIVITY_ID = FASG.ACTIVITY_ID AND PT.TEAM_MEMBER = PD.EMPLID AND FRT.RATE_ELEMENT = FRE.RATE_ELEMENT AND FASG.BUSINESS_UNIT = SCR.SETCNTRLVALUE AND SCR.RECNAME = 'FO_RATE_ELEMENT' AND SCR.SETID = FRE.SETID AND FRE.RATE_PURPOSE = 'R' AND FASG.ASSIGNMENT_ID = FDT.ASSIGNMENT_ID AND FASG.ASSIGNMENT_ID = FSTS.ASSIGNMENT_ID AND FSTS.LASTUPDDTTM = ( SELECT MAX(S_ED.LASTUPDDTTM) FROM PS_RS_ASSGN_STS S_ED WHERE FSTS.ASSIGNMENT_ID = S_ED.ASSIGNMENT_ID ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | FO_SHIP_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Site |
| 4 | OWNERSHIP_ID | Character(30) | VARCHAR2(30) NOT NULL | Owning Organization |
| 5 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 6 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 7 | SO_LINE | Number(3,0) | SMALLINT NOT NULL | Line Number |
| 8 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
| 9 | ASSIGN_STS | Character(2) | VARCHAR2(2) NOT NULL |
Assignment Status
A=Assign C=Complete I=Interview P=Propose R=Reject S=Reserve V=Pending Approval X=Cancel |
| 10 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 11 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 14 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 15 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 16 | END_DATE | Date(10) | DATE | End Date |
| 17 | PAY_RATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Pay Rate |
| 18 | RATE_AMT | Number(30,6) | DECIMAL(29,6) NOT NULL | Rate Amount for Rates. |
| 19 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |