| # |
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 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
XTRCT_FILE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Extract File Format
C=Comma Separated Values
J=JetForm
L=Line Printer
O=Other
W=MS-Word
Default Value: C
|
| 4 |
COMM_ID_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Communication ID Select Option
A=All IDs
E=All Person IDs
O=One Org ID
R=All Org IDs
S=One Person ID
Default Value: A
|
| 5 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
COMM_LTR_SRCH
|
| 6 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
COMM_ORG_SRCH
|
| 7 |
SALUT_NAME_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Salutation Name
Prompt Table:
NAME_USAGE_VW
|
| 8 |
ADDR_NAME_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Name
Prompt Table:
NAME_USAGE_VW
|
| 9 |
ADDR_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table:
ADDR_USAGE_TBL
|
| 10 |
JOINT_NAME_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Joint Name Usage
Prompt Table:
J_NAME_USAGE_VW
|
| 11 |
SCC_LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Letter Code
Prompt Table:
%EDITTABLE
|
| 12 |
DATE_PRINTED_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Letter Printed Option
C=Communication Date
D=User Supplied Date
S=System Date
Default Value: S
|
| 13 |
LETTER_PRINTED_DT |
Date(10) |
DATE |
Date letter was printed
|
| 14 |
DATE_COMPLETED_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Activity Completed Option
C=Communication Date
D=User Supplied Date
S=System Date
Default Value: S
|
| 15 |
COMPLETED_DT |
Date(10) |
DATE |
Date Activity Completed
|
| 16 |
FROM_DT |
Date(10) |
DATE NOT NULL |
From Date
Default Value: %date
|
| 17 |
TO_DT |
Date(10) |
DATE NOT NULL |
To Date
Default Value: %date
|
| 18 |
CHECKLIST_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Checklist Code
Prompt Table:
%EDITTABLE2
|
| 19 |
CHECKLST_INITIATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Checklist Initiated
Y/N Table Edit
Default Value: Y
|
| 20 |
CHECKLST_COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Checklist Completed
Y/N Table Edit
Default Value: N
|
| 21 |
ITEM_INITIATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Initiated
Y/N Table Edit
Default Value: Y
|
| 22 |
ITEM_COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Completed
Y/N Table Edit
Default Value: N
|
| 23 |
ITEM_NOTIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Notified
Y/N Table Edit
Default Value: Y
|
| 24 |
ITEM_SECOND_NTFCTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Second Notification
Y/N Table Edit
Default Value: Y
|
| 25 |
ITEM_WAIVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Waived
Y/N Table Edit
Default Value: N
|
| 26 |
TRACKING_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Tracking Group
Prompt Table:
%EDITTABLE3
|
| 27 |
TRK_GRP_INITIATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tracking Group Initiated
Y/N Table Edit
Default Value: Y
|
| 28 |
TRK_GRP_COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tracking Group Completed
Y/N Table Edit
Default Value: N
|
| 29 |
PRODUCE_COMM |
Character(1) |
VARCHAR2(1) NOT NULL |
Produce Communication
Y/N Table Edit
Default Value: Y
|
| 30 |
COMPLETE_COMM |
Character(1) |
VARCHAR2(1) NOT NULL |
Complete Communication
Y/N Table Edit
Default Value: Y
|
| 31 |
SCC_CHECKLIST_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Checklist Type.
ADC=Condition List
CML=Communication List
HIR=Hiring
MED=Medical
OTH=Other
PRM=Promise
RQL=Requirements List
SAL=Staff Assignment List
TER=Termination
TRN=Training
XFR=Transfer
|
| 32 |
EXTRACT_NAME_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
ID Extract Name Usage
Prompt Table:
NAME_USAGE_VW
|
| 33 |
FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 34 |
TEMPLATE_PATH |
Character(80) |
VARCHAR2(80) NOT NULL |
Template Path
|
| 35 |
SORT_OPTION_LTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Option for Letter Gen
1=Country, Postal
2=Last Name, First Name
|
| 36 |
PRINT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Send to Printer
Y/N Table Edit
Default Value: N
|