SS_KEYFIELDS (SQL Table)	Index Back
SS Framework Core Key Fields Used in Self Service Framework. Used on Admin Subpage to unalias self service data to meaningful Core Key Fields. SS Buffer Use field tells which record holds the key values required to do the unalias.

SS_KEYFIELDS

(SQL Table)

SS Framework Core Key Fields

Used in Self Service Framework. Used on Admin Subpage to unalias self service data to meaningful Core Key Fields. SS Buffer Use field tells which record holds the key values required to do the unalias.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name

2 KEYNAME Character(18) VARCHAR2(18) NOT NULL Key Name

3 SS_BUFFER_USE Character(1) VARCHAR2(1) NOT NULL Used in SS Framework
A=Approve Temp Scroll
D=Deny Temp Scroll
E=Edit Scroll
H=Header
L=Detail Scroll
P=Process Detail Scroll
S=Search Record
V=Save For Ltr Scroll

4 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name
2	KEYNAME	Character(18)	VARCHAR2(18) NOT NULL	Key Name
3	SS_BUFFER_USE	Character(1)	VARCHAR2(1) NOT NULL	Used in SS Framework A=Approve Temp Scroll D=Deny Temp Scroll E=Edit Scroll H=Header L=Detail Scroll P=Process Detail Scroll S=Search Record V=Save For Ltr Scroll
4	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.