| # |
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 |
SSR_ELEM_545_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Commonwealth Learning Scholarship code
1=CECS Education Costs Schol'shp
2=CAS Accommodation Scholarship
3=CECS Associate Degree
4=CAS Associate Degree
5=CECS Indigenous Enabling
6=CAS Indigenous Enabling
7=Indigenous Access
7=CAS Indigenous Payment
8=National Priority
9=National Accommodation
A=Indigenous Education
B=Indigenous Accommodation
C=Indigenous Reward
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
SSR_ELEM_526_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Commonwealth Learning Scholarship status code
0=Not in receipt of CLS
0=Not in Receipt of Scholarship
1=Current CLS
1=Current Scholarship
2=Deferred Scholarship
2=Deferred CLS
3=Terminated Scholarship
3=Terminated CLS
4=CAS Indigenous Payment Accept
5=CAS Indigenous Payment Confirm
6=CAS Indigenous Payment Failed
7=Offered Scholarship
|
| 5 |
SSR_ELEM_538_TERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Commonwealth Learning Scholarship termination code
0=Scholarship Active
1=Course Complete
2=Full Period Consumed
3=Unsatisfactory Progress
4=No Longer Eligible
5=Failed to comply with Sch Cond
|
| 6 |
SSR_E545_ALLOC_DT |
Date(10) |
DATE |
This field contains the Allocate Date for element E545 in DEST reporting
|
| 7 |
SSR_E545_ACCEPT_DT |
Date(10) |
DATE |
This field contains the acceptance date for element number 545 in DEST reporting
|
| 8 |
SSR_HM_END_DT |
Date(10) |
DATE |
CS End Date
|
| 9 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 10 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 11 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 12 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 13 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|