AMIF_CUSTOD_AET(SQL Table) |
Index Back |
---|---|
Trans Loader - Custodian AETTransation Loader - Custodian AET |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
5 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
6 | CUSTODIAN | Character(30) | VARCHAR2(30) NOT NULL | Custodian |
7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
8 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
9 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
10 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
11 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
12 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
13 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
14 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
15 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
16 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
17 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
18 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
19 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
20 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
21 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
22 | OFFSITE_SW | Character(1) | VARCHAR2(1) NOT NULL | This Asset is Offsite |
23 | AUTH_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Authorization Status
A=Authorized N=Not Authorized P=Authorization Pending |
24 | AUTHORIZATION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Authorization Name |
25 | AUTHORIZATION_DT | Date(10) | DATE | Date Authorized |
26 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |