| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 2 |
BILLING_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Billing Career
|
| 3 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 4 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Default Value: OPR_DEF_TBL_CS.STRM
Prompt Table:
TERM_VAL_TBL
|
| 5 |
VARIABLE_CHAR1 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #1
|
| 6 |
VARIABLE_CHAR2 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #2
|
| 7 |
VARIABLE_CHAR3 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #3
|
| 8 |
VARIABLE_CHAR4 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #4
|
| 9 |
VARIABLE_CHAR5 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #5
|
| 10 |
VARIABLE_CHAR6 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #6
|
| 11 |
VARIABLE_CHAR7 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #7
|
| 12 |
VARIABLE_CHAR8 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #8
|
| 13 |
VARIABLE_CHAR9 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #9
|
| 14 |
VARIABLE_CHAR10 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #10
|
| 15 |
VARIABLE_FLAG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #1
Y/N Table Edit
Default Value: N
|
| 16 |
VARIABLE_FLAG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #2
Y/N Table Edit
Default Value: N
|
| 17 |
VARIABLE_FLAG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #3
Y/N Table Edit
Default Value: N
|
| 18 |
VARIABLE_FLAG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #4
Y/N Table Edit
Default Value: N
|
| 19 |
VARIABLE_FLAG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #5
Y/N Table Edit
Default Value: N
|
| 20 |
VARIABLE_FLAG6 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #6
Y/N Table Edit
Default Value: N
|
| 21 |
VARIABLE_FLAG7 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #7
Y/N Table Edit
Default Value: N
|
| 22 |
VARIABLE_FLAG8 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #8
Y/N Table Edit
Default Value: N
|
| 23 |
VARIABLE_FLAG9 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #9
Y/N Table Edit
Default Value: N
|
| 24 |
VARIABLE_FLAG10 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #10
Y/N Table Edit
Default Value: N
|
| 25 |
VARIABLE_NUM1 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #1
|
| 26 |
VARIABLE_NUM2 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numerice #2
|
| 27 |
VARIABLE_NUM3 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #3
|
| 28 |
VARIABLE_NUM4 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #4
|
| 29 |
VARIABLE_NUM5 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #5
|
| 30 |
VARIABLE_NUM6 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #6
|
| 31 |
VARIABLE_NUM7 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #7
|
| 32 |
VARIABLE_NUM8 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #8
|
| 33 |
VARIABLE_NUM9 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #9
|
| 34 |
VARIABLE_NUM10 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #10
|