RTBL_CAF_CONTRL (SQL Table)	Index Back
RTBL CAF Control Table RTBL CAF Control Table to maintian the last session id displayed in CAF for a user/scenario.

RTBL_CAF_CONTRL

(SQL Table)

RTBL CAF Control Table

RTBL CAF Control Table to maintian the last session id displayed in CAF for a user/scenario.

# 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 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID

3 CAF_SESSION_ID Character(36) VARCHAR2(36) NOT NULL Session ID

4 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes
Default Value: N

5 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default
Default Value: N

6 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SCE_ID	Character(10)	VARCHAR2(10) NOT NULL	ID
3	CAF_SESSION_ID	Character(36)	VARCHAR2(36) NOT NULL	Session ID
4	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes Default Value: N
5	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Default Default Value: N
6	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.