SUJ--Modified to list only Resource Management Assignments

RS_ASSGN_SO_VW4

(SQL View)
 Index Back

SELECT A.ASSIGNMENT_ID , A.EMPLID , A1.START_DT , A1.END_DT , A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.PROJECT_ID , A.PROJ_ROLE , A.CUST_ID , A.ADDRESS_SEQ_NUM , A.TASK_TYPE , A1.SUN , A1.MON , A1.TUES , A1.WED , A1.THURS , A1.FRI , A1.SAT , A1.PERCENTAGE , A1.TIME_START , A1.SCHEDULED_HRS , A.DESCR , A.ASSIGNED_TO , A.RESERVED_FLAG , A.DESCR254_MIXED , B.ASSIGN_STS FROM %Table(RS_ASSIGNMENT) A , %Table(RS_ASSIGNDET_VW) A1 , %Table(RS_ASSGN_STS) B WHERE A.ASSIGNMENT_ID = A1.ASSIGNMENT_ID AND A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND A.SYSTEM_SOURCE = 'RS' AND B.LASTUPDDTTM = ( SELECT MAX(C.LASTUPDDTTM) FROM %Table(RS_ASSGN_STS) C WHERE C.ASSIGNMENT_ID = B.ASSIGNMENT_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

Default Value: NEXT

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

3 START_DT Date(10) DATE Start Date
4 END_DT Date(10) DATE End Date
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

6 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

Prompt Table: RS_SO_SRCH_VW

7 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

Prompt Table: RS_SO_LN_SCH_VW

8 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJ_SRCH

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

Prompt Table: PROJ_ROLE

10 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: RS_SHIP_CUST_VW

11 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
12 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category

Prompt Table: RS_TASK_TYPE

13 SUN Character(1) VARCHAR2(1) NOT NULL Sunday

Y/N Table Edit

Default Value: INSTALLATION_RS.SUN

14 MON Character(1) VARCHAR2(1) NOT NULL Monday

Y/N Table Edit

Default Value: INSTALLATION_RS.MON

15 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday

Y/N Table Edit

Default Value: INSTALLATION_RS.TUES

16 WED Character(1) VARCHAR2(1) NOT NULL Wednesday

Y/N Table Edit

Default Value: INSTALLATION_RS.WED

17 THURS Character(1) VARCHAR2(1) NOT NULL Thursday

Y/N Table Edit

Default Value: INSTALLATION_RS.THURS

18 FRI Character(1) VARCHAR2(1) NOT NULL Friday

Y/N Table Edit

Default Value: INSTALLATION_RS.FRI

19 SAT Character(1) VARCHAR2(1) NOT NULL Saturday

Y/N Table Edit

Default Value: INSTALLATION_RS.SAT

20 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

Default Value: 1

21 TIME_START Time(15) TIMESTAMP Start Time

Default Value: INSTALLATION_RS.TIME_START

22 SCHEDULED_HRS Signed Number(10,4) DECIMAL(8,4) NOT NULL Scheduled Hours
23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
24 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To
25 RESERVED_FLAG Character(1) VARCHAR2(1) NOT NULL Reserved Flag
B=Both
N=No
Y=Yes

Y/N Table Edit

Default Value: N

26 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
27 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