FO_ASGN_DTL_VW (SQL View)	Index Back
Track Assigment Replacements

FO_ASGN_DTL_VW

(SQL View)

Track Assigment Replacements

SELECT ASSIGNMENT_ID , SEQNO , HIST_SEQ , START_DT_OLD , START_DT_NEW , END_DT_OLD , END_DT_NEW , REQUEST_DT , CHANGE_REASON_DT , COMMENT1 , LAST_UPDATED_BY , LAST_UPDATE_DTTM FROM PS_FO_ASGN_DTL_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

2 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
Default Value: 1

3 HIST_SEQ Number(9,0) DECIMAL(9) NOT NULL History sequence number

4 START_DT_OLD Date(10) DATE Old Start Date : means start date before change is made to the start date

5 START_DT_NEW Date(10) DATE Old Start Date : means start date before change is made to the start date

6 END_DT_OLD Date(10) DATE Old End Date

7 END_DT_NEW Date(10) DATE Old End Date

8 REQUEST_DT Date(10) DATE Request Date

9 CHANGE_REASON_DT Character(3) VARCHAR2(3) NOT NULL Change Reason
BEH=Inappropriate behaviour
BUS=More business sold
DEC=Decreased workload due to proj
DIS=Dissatisfaction of service
EXT=Project was extended
INI=INI
LES=Less work than originally
PEK=Peak period
RES=Resource unable to finish wrk
SAT=Satisfaction of service

10 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments

11 LAST_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL LastUpdatedUser

12 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ASSIGNMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Assignment ID
2	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 1
3	HIST_SEQ	Number(9,0)	DECIMAL(9) NOT NULL	History sequence number
4	START_DT_OLD	Date(10)	DATE	Old Start Date : means start date before change is made to the start date
5	START_DT_NEW	Date(10)	DATE	Old Start Date : means start date before change is made to the start date
6	END_DT_OLD	Date(10)	DATE	Old End Date
7	END_DT_NEW	Date(10)	DATE	Old End Date
8	REQUEST_DT	Date(10)	DATE	Request Date
9	CHANGE_REASON_DT	Character(3)	VARCHAR2(3) NOT NULL	Change Reason BEH=Inappropriate behaviour BUS=More business sold DEC=Decreased workload due to proj DIS=Dissatisfaction of service EXT=Project was extended INI=INI LES=Less work than originally PEK=Peak period RES=Resource unable to finish wrk SAT=Satisfaction of service
10	COMMENT1	Character(254)	VARCHAR2(254) NOT NULL	Comments
11	LAST_UPDATED_BY	Character(30)	VARCHAR2(30) NOT NULL	LastUpdatedUser
12	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.