SPB_ASGNBYSRV_V(SQL View) |
Index Back |
|---|---|
Assignment by Service/Job CodeAssignment by Service/Job Code |
| SELECT A.SETID , A.PROJ_ROLE , A.ASSIGNMENT_ID , A.EFFDT , A.EFF_STATUS , B.DESCR60 , A.ASSIGNMENT_PAY , A.ASSIGNMENT_PCT , A.ASSIGNMENT_RT , A.ASSIGNMENT_INCDT , A.ASSIGNMENT_INCRATE FROM PS_SPB_ASGN_BY_SRV A , PS_SPB_ASSIGNMENT B WHERE A.SETID = B.SETID AND A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND %EffdtCheck(SPB_ASGN_BY_SRV,A,%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table: SPB_PJROL_R_VW1 |
| 3 | ASSIGNMENT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Work Assignment ID
Prompt Table: SPB_ASGN_VW |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 7 | ASSIGNMENT_PAY | Character(1) | VARCHAR2(1) NOT NULL |
Assignment Pay
A=Add to Work Order Rate P=Add % of Work Order Rate S=Substitute Work Order Rate |
| 8 | ASSIGNMENT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Assignment Percent |
| 9 | ASSIGNMENT_RT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Assignment Rate |
| 10 | ASSIGNMENT_INCDT | Character(1) | VARCHAR2(1) NOT NULL |
Assignment Based on Incident
Y/N Table Edit Default Value: N |
| 11 | ASSIGNMENT_INCRATE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Assignment Incident Rate |