RE_CLAUSE_STYPE (SQL Table)	Index Back
Sub Clause Code This Record Stores Sub Clause Codes. and it will be a level 2 grid in the clause scroll.

RE_CLAUSE_STYPE

(SQL Table)

Sub Clause Code

This Record Stores Sub Clause Codes. and it will be a level 2 grid in the clause scroll.

Related Language Record: RE_CLSSTYPE_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 CLAUSE_CD Character(10) VARCHAR2(10) NOT NULL Clause Type Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 SCLAUSE_CD Number(10,0) DECIMAL(10) NOT NULL Sub Clause Code

5 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Clause Subtype

6 INSTANCE_DESCR Character(150) VARCHAR2(150) NOT NULL Generic Description Field for Instances of Generic Entities

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	CLAUSE_CD	Character(10)	VARCHAR2(10) NOT NULL	Clause Type Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	SCLAUSE_CD	Number(10,0)	DECIMAL(10) NOT NULL	Sub Clause Code
5	INSTANCE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Clause Subtype
6	INSTANCE_DESCR	Character(150)	VARCHAR2(150) NOT NULL	Generic Description Field for Instances of Generic Entities