| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TRANSACTION_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
EDI Transaction Name
|
| 2 |
SS_CONFIG_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in SS Framework
1=DB Updates N, Appr Req Y
2=DB Updates N, Appr Req N
3=DB Updates Y, Appr Req Y
4=DB Updates Y, Appr Req N
5=CI Administrator Option
|
| 3 |
SS_STAT_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Used on "_DAT" records for 8.3 Workflow Enhancements
A=Approved
B=CI failed - Errors & Warnings
C=Cancelled
D=Denied
E=Errors Encountered
I=In Approval Process
M=Administrator Action Required
S=Success
W=Warnings Encountered
|
| 4 |
SS_COMP_USE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used in SS Framework
ADM=Administrator
APL=Approval List
APR=Approver
COR=Core
ORG=Originator
STL=Status List
STS=Status
|
| 5 |
SS_COMP_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
SS Component Process
B=Component Build
P=Component SavePostChange
|
| 6 |
SS_PAGE_AREA |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in SS Framework
A=Approved Temp Area
D=Deny Temp Area
E=Edit Area
H=Header
|
| 7 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 8 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 9 |
LEVELNUM |
Number(5,0) |
INTEGER NOT NULL |
Level Number
|
| 10 |
WHICH_ROW_OR_ROWS |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in SS Framework
A=All Rows
F=First Row
L=Last Row
|
| 11 |
VISIBLE_PROPERTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in SS Framework
|
| 12 |
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.
|