CS_TLEXP_DT_TMP

(SQL Table)
Index Back

Explosion Date Table

SCC 09/01/04 - Date Table to use for Explosion when getting Effective Date records

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
4 CS_OBJECT_TYPE_SRC Character(4) VARCHAR2(4) NOT NULL Source Object Type
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0010=All
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 TEMP_DT Date(10) DATE Temp Date