| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
PROCESSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 5 |
RUNDTTM |
DateTime(26) |
TIMESTAMP |
Run Date/Time
|
| 6 |
RUNDATE |
Date(10) |
DATE |
Process Scheduler Run Date
|
| 7 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 8 |
AGING_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
Aging Set
Prompt Table:
AGING_TBL
|
| 9 |
EMPLID_SW1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Emplid Switch
E=By Emplid
O=By Org ID
|
| 10 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID
|
| 11 |
CREDIT_HISTORY_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit History Update Flag
A=All IDs
D=Last Activity Date
O=One ID
R=ID Range
T=Temp Table
Default Value: A
|
| 12 |
LAST_ACTIVITY_DATE |
Date(10) |
DATE |
Last Activity Date
|
| 13 |
START_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Start EmplID
Prompt Table:
PEOPLE_SRCH
|
| 14 |
START_EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Start Ext Org ID
Prompt Table:
EXT_ORG_TBL
|
| 15 |
END_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
End EmplID
Prompt Table:
PEOPLE_SRCH
|
| 16 |
END_EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
End Ext Org ID
Prompt Table:
EXT_ORG_TBL
|
| 17 |
SOURCE_IND_UPDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Indicator Update
Y/N Table Edit
Default Value: N
|
| 18 |
SRVC_IND_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Indicator Set
Prompt Table:
SRVC_IND_SF_TBL
|
| 19 |
PLACED_PERSON_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
ID of person who placed the Service Indicator
Prompt Table:
PEOPLE_SRCH
|
| 20 |
SERVICE_IMPACT_SF |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Impact SF
Prompt Table:
SSF_SVCIMP_D_VW
|
| 21 |
BACKDATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Back Date Flag
Y/N Table Edit
Default Value: N
|
| 22 |
BACKDATE_DT |
Date(10) |
DATE |
Back Date
|
| 23 |
SSF_MAX_AGE_CAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Max Aging Category
|
| 24 |
SSF_ACTDATE_OPTNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Activity Date Options
D=Use This Date
L=Use Last Run Date
R=Use Run Date Minus (days)
Default Value: D
|
| 25 |
SSF_TEMP_LACTY_DT |
Date(10) |
DATE |
Last Activity Date
|
| 26 |
SSF_ACTDATE_REL |
Number(3,0) |
SMALLINT NOT NULL |
Last Activity Date Options
Default Value: 1
|
| 27 |
SSF_TEMP_PROC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Only
A=Last Activity and Age History
L=Last Activity
R=To Release Service Indicators
Default Value: L
|
| 28 |
SCCPS_POP_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.
Y/N Table Edit
Default Value: Y
|
| 29 |
SCCPS_TOOL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Tool ID - the unique key for a pop select tool
Prompt Table:
SCCPS_TOOL_VW
|
| 30 |
SCCPS_QUERY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Query / Section name used by population selection
Prompt Table:
%EDITTABLE
|
| 31 |
SCCPS_CNTXT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Context ID - the unique key that identifies the pop selection context
Prompt Table:
SCCPS_CNTXT_VW
|
| 32 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 33 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 34 |
SCCPS_FILE_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Pop Select File Path and Name
|
| 35 |
SSF_NBR_PROC |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of Students Processed
|