RS_SCHED_NSN_VW (SQL View)	Index Back
RM Schedule Seqno Calculation Use to find the next schedule seqno for a given EMPLID and DATE. SUJ--Included SYSTEM_SOURCE field.

RS_SCHED_NSN_VW

(SQL View)

RM Schedule Seqno Calculation

Use to find the next schedule seqno for a given EMPLID and DATE. SUJ--Included SYSTEM_SOURCE field.

SELECT EMPLID , DATE_UNDER_RPT , MAX(A.SEQNO)+1 ,SYSTEM_SOURCE FROM %Table(RS_SCHED_TASK) A GROUP BY A.EMPLID , A.DATE_UNDER_RPT ,SYSTEM_SOURCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DATE_UNDER_RPT Date(10) DATE NOT NULL Date Under Report
Default Value: %date

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

4 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	DATE_UNDER_RPT	Date(10)	DATE NOT NULL	Date Under Report Default Value: %date
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 0
4	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.